Query Metrics
80
Database Queries
9
Different statements
66.61 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
28.56 ms (42.87%) |
34 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock_number AS stock_number_3, t0.stock_room_number AS stock_room_number_4, t0.stock_row_number AS stock_row_number_5, t0.stock_row_place_number AS stock_row_place_number_6, t0.ean AS ean_7, t0.plu AS plu_8, t0.volume AS volume_9, t0.stock AS stock_10, t0.price AS price_11, t0.created AS created_12, t0.updatedTime AS updatedTime_13, t0.lowLimit AS lowLimit_14, t0.notificationOn AS notificationOn_15, t0.timeLimit AS timeLimit_16, t0.created_by_id AS created_by_id_17 FROM components t0 INNER JOIN products_components ON t0.id = products_components.components_id WHERE products_components.products_id = ?
Parameters:
[
511
]
|
23.68 ms (35.55%) |
34 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_by_id AS created_by_id_3 FROM alergen t0 INNER JOIN products_alergen ON t0.id = products_alergen.alergen_id WHERE products_alergen.products_id = ?
Parameters:
[
511
]
|
7.08 ms (10.63%) |
6 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.description AS description_4, t0.name_in_shop_menu AS name_in_shop_menu_5, t0.plu AS plu_6, t0.sort_id AS sort_id_7, t0.number_in_menu AS number_in_menu_8, t0.ean AS ean_9, t0.kod_synchro AS kod_synchro_10, t0.device_id AS device_id_11, t0.color AS color_12, t0.enable_menu AS enable_menu_13, t0.enable_shop AS enable_shop_14, t0.suppliment AS suppliment_15, t0.is_holding_set AS is_holding_set_16, t0.has_variable_price AS has_variable_price_17, t0.used_in_orderterminal AS used_in_orderterminal_18, t0.unuque_id AS unuque_id_19, t0.price AS price_20, t0.calories AS calories_21, t0.price_happy_hour AS price_happy_hour_22, t0.product_consisted AS product_consisted_23, t0.product_tax AS product_tax_24, t0.static_tax AS static_tax_25, t0.max_product_discount AS max_product_discount_26, t0.stock_room AS stock_room_27, t0.stock_place AS stock_place_28, t0.buy_price AS buy_price_29, t0.weight AS weight_30, t0.min_unit AS min_unit_31, t0.is_service AS is_service_32, t0.min_unit_count AS min_unit_count_33, t0.image_name AS image_name_34, t0.image_size AS image_size_35, t0.updated_at AS updated_at_36, t0.status_id AS status_id_37, t0.artikel_weight_type_id AS artikel_weight_type_id_38, t0.created_by_id AS created_by_id_39, t0.tax_id AS tax_id_40, t0.category_id AS category_id_41 FROM products t0 WHERE t0.created_by_id = ? AND t0.category_id = ?
Parameters:
[ 1210 40 ] |
1.78 ms (2.67%) |
1 |
SELECT t0.id AS id_1, t0.mon_on AS mon_on_2, t0.mon_start AS mon_start_3, t0.mon_end AS mon_end_4, t0.sun_on AS sun_on_5, t0.sun_start AS sun_start_6, t0.sun_end AS sun_end_7, t0.tue_on AS tue_on_8, t0.tue_start AS tue_start_9, t0.tue_end AS tue_end_10, t0.wed_on AS wed_on_11, t0.wed_start AS wed_start_12, t0.wed_end AS wed_end_13, t0.thur_on AS thur_on_14, t0.thur_start AS thur_start_15, t0.thur_end AS thur_end_16, t0.fri_on AS fri_on_17, t0.fri_start AS fri_start_18, t0.fri_end AS fri_end_19, t0.sat_on AS sat_on_20, t0.sat_start AS sat_start_21, t0.sat_end AS sat_end_22, t0.created_by_id AS created_by_id_23 FROM business_time t0 WHERE t0.created_by_id = ? LIMIT 1
Parameters:
[
1210
]
|
1.69 ms (2.54%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.color AS color_4, t0.kod_sinchro AS kod_sinchro_5, t0.device_id AS device_id_6, t0.sort_id AS sort_id_7, t0.kasse_cat_id AS kasse_cat_id_8, t0.mode AS mode_9, t0.not_print_saldo AS not_print_saldo_10, t0.allway_single_saldo AS allway_single_saldo_11, t0.enable_menu AS enable_menu_12, t0.enable_shop AS enable_shop_13, t0.image_name AS image_name_14, t0.image_size AS image_size_15, t0.updated_at AS updated_at_16, t0.created_by_id AS created_by_id_17 FROM category t0 WHERE t0.created_by_id = ?
Parameters:
[
1210
]
|
1.52 ms (2.28%) |
1 |
SELECT t0.id AS id_1, t0.shop_owner AS shop_owner_2, t0.shop_description AS shop_description_3, t0.shop_agb AS shop_agb_4, t0.unique_shop_id AS unique_shop_id_5, t0.shop_url AS shop_url_6, t0.currency AS currency_7, t0.shop_datenshutz AS shop_datenshutz_8, t0.connector AS connector_9, t0.api_key AS api_key_10, t0.order_prefix AS order_prefix_11, t0.shop_telegram_api AS shop_telegram_api_12, t0.cookies AS cookies_13, t0.geschaft_name AS geschaft_name_14, t0.status_user AS status_user_15, t0.interval_data AS interval_data_16, t0.account_enabled AS account_enabled_17, t0.shop_enabled AS shop_enabled_18, t0.menu_enabled AS menu_enabled_19, t0.image_name_logo AS image_name_logo_20, t0.image_size_logo AS image_size_logo_21, t0.updated_at_logo AS updated_at_logo_22, t0.shop_type_id AS shop_type_id_23, t0.created_by_id AS created_by_id_24, t0.menu_setting_id AS menu_setting_id_25, t0.shop_setting_id AS shop_setting_id_26 FROM shop_data t0 WHERE t0.shop_url = ? LIMIT 1
Parameters:
[
"isi-kebap-haus"
]
|
0.98 ms (1.48%) |
1 |
SELECT t0.id AS id_1, t0.geschaft_website AS geschaft_website_2, t0.geschaft_email AS geschaft_email_3, t0.geschaft_fax AS geschaft_fax_4, t0.geschaft_tel AS geschaft_tel_5, t0.geschaft_city AS geschaft_city_6, t0.geschaft_address AS geschaft_address_7, t0.geschaft_hnumber AS geschaft_hnumber_8, t0.geschaft_zip AS geschaft_zip_9, t0.geschaft_steuer AS geschaft_steuer_10, t0.geschaft_inh AS geschaft_inh_11, t0.hbr AS hbr_12, t0.geschaft_bank AS geschaft_bank_13, t0.geschaft_iban AS geschaft_iban_14, t0.geschaft_bic AS geschaft_bic_15, t0.registergericht AS registergericht_16, t0.handelsregisternummer AS handelsregisternummer_17, t0.geschaft_corp_id AS geschaft_corp_id_18, t0.created_by_id AS created_by_id_19 FROM impressum t0 WHERE t0.created_by_id = ? LIMIT 1
Parameters:
[
1210
]
|
0.72 ms (1.08%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM delivery t0 INNER JOIN shop_data_delivery ON t0.id = shop_data_delivery.delivery_id WHERE shop_data_delivery.shop_data_id = ?
Parameters:
[
2
]
|
0.61 ms (0.91%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM payments t0 INNER JOIN shop_data_payments ON t0.id = shop_data_payments.payments_id WHERE shop_data_payments.shop_data_id = ?
Parameters:
[
2
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\ShopData | No errors. |
App\Entity\ShopTypes | No errors. |
App\Entity\Users | No errors. |
App\Entity\MenuSetting | No errors. |
App\Entity\ShopSetting | No errors. |
App\Entity\ShopTags | No errors. |
App\Entity\Delivery | No errors. |
App\Entity\Payments | No errors. |
App\Entity\Category | No errors. |
App\Entity\ProductCars | No errors. |
App\Entity\Impressum | No errors. |
App\Entity\Coorp | No errors. |
App\Entity\BusinessTime | No errors. |
App\Entity\Products | No errors. |
App\Entity\StatusProduct | No errors. |
App\Entity\ArtikelWeightType | No errors. |
App\Entity\Tax | No errors. |
App\Entity\Components | No errors. |
App\Entity\Alergen | No errors. |
App\Entity\Playlists | No errors. |