POST https://audit.northco.cc/api/start-audit

Query Metrics

39 Database Queries
11 Different statements
18.60 ms Query time
0 Invalid entities
272 Managed entities

Grouped Statements

Show all queries

Time Count Info
3.33 ms
(17.90%)
5
SELECT t0.id AS id_1, t0.position AS position_2, t0.text AS text_3, t0.description AS description_4, t0.type AS type_5, t0.answer_type AS answer_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.required_id AS required_id_9, t0.required AS required_10, t0.active AS active_11, t0.replicable AS replicable_12 FROM product_indicator t0 INNER JOIN products_indicators ON t0.id = products_indicators.product_indicator_id WHERE products_indicators.product_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
3.17 ms
(17.07%)
9
SELECT t0.id AS id_1, t0.answer AS answer_2, t0.type AS type_3, t0.position AS position_4, t0.point AS point_5, t0.value AS value_6, t0.required_id AS required_id_7, t0.calculate_id AS calculate_id_8, t0.calculated AS calculated_9, t0.active AS active_10, t0.required AS required_11, t0.thumb AS thumb_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.indicator_id AS indicator_id_15 FROM pdv_indicator_answer t0 WHERE t0.indicator_id = ?
Parameters:
[
  1
]
2.91 ms
(15.67%)
4
SELECT t0.id AS id_1, t0.name AS name_2, t0.reseller AS reseller_3, t0.thumb AS thumb_4, t0.thumb_link AS thumb_link_5, t0.sku AS sku_6, t0.ean AS ean_7, t0.value AS value_8, t0.active AS active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM product_mix t0 INNER JOIN products_mixes ON t0.id = products_mixes.product_mix_id WHERE products_mixes.product_id = ? ORDER BY t0.name ASC
Parameters:
[
  1
]
2.35 ms
(12.63%)
7
SELECT t0.id AS id_1, t0.answer AS answer_2, t0.type AS type_3, t0.position AS position_4, t0.point AS point_5, t0.value AS value_6, t0.required_id AS required_id_7, t0.calculate_id AS calculate_id_8, t0.calculated AS calculated_9, t0.active AS active_10, t0.required AS required_11, t0.thumb AS thumb_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.indicator_id AS indicator_id_15 FROM product_indicator_answer t0 WHERE t0.indicator_id = ?
Parameters:
[
  1
]
1.88 ms
(10.09%)
5
SELECT t0.id AS id_1, t0.trade_name AS trade_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.active AS active_5 FROM product_direc_competition t0 INNER JOIN products_competitors ON t0.id = products_competitors.product_direc_competition_id WHERE products_competitors.product_id = ?
Parameters:
[
  1
]
1.03 ms
(5.55%)
2
SELECT t0.id AS id_1, t0.position AS position_2, t0.text AS text_3, t0.description AS description_4, t0.type AS type_5, t0.answer_type AS answer_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.required_id AS required_id_9, t0.required AS required_10, t0.replicable AS replicable_11, t0.active AS active_12 FROM product_direc_competition_indicator t0 INNER JOIN product_direc_competion_indicators ON t0.id = product_direc_competion_indicators.product_direc_competition_indicator_id WHERE product_direc_competion_indicators.product_direc_competition_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
1.01 ms
(5.42%)
3
SELECT t0.id AS id_1, t0.answer AS answer_2, t0.type AS type_3, t0.position AS position_4, t0.point AS point_5, t0.value AS value_6, t0.required_id AS required_id_7, t0.calculate_id AS calculate_id_8, t0.calculated AS calculated_9, t0.active AS active_10, t0.required AS required_11, t0.thumb AS thumb_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.indicator_id AS indicator_id_15 FROM product_direc_competition_indicator_answer t0 WHERE t0.indicator_id = ?
Parameters:
[
  1
]
0.85 ms
(4.58%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.text AS text_3, t0.description AS description_4, t0.type AS type_5, t0.answer_type AS answer_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.required_id AS required_id_9, t0.required AS required_10, t0.replicable AS replicable_11, t0.active AS active_12 FROM pdv_indicator t0 INNER JOIN pdv_indicators ON t0.id = pdv_indicators.pdv_indicator_id WHERE pdv_indicators.pdv_id = ? ORDER BY t0.position ASC
Parameters:
[
  50
]
0.83 ms
(4.48%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.sku AS sku_4, t0.barcode AS barcode_5, t0.qrcode AS qrcode_6, t0.thumb AS thumb_7, t0.description AS description_8, t0.type AS type_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.active AS active_12 FROM product t0 INNER JOIN pdv_products ON t0.id = pdv_products.product_id WHERE pdv_products.pdv_id = ? ORDER BY t0.position ASC
Parameters:
[
  50
]
0.62 ms
(3.34%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.retail AS retail_4, t0.distributor AS distributor_5, t0.cnpj AS cnpj_6, t0.static_map AS static_map_7, t0.address AS address_8, t0.number AS number_9, t0.zip_code AS zip_code_10, t0.neighborhood AS neighborhood_11, t0.city AS city_12, t0.state AS state_13, t0.country AS country_14, t0.lat AS lat_15, t0.lng AS lng_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.active AS active_19, t0.client_id AS client_id_20 FROM pdv t0 WHERE t0.id = ?
Parameters:
[
  "50"
]
0.61 ms
(3.27%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.cpf AS cpf_4, t0.avatar AS avatar_5, t0.token AS token_6, t0.firebase_token AS firebase_token_7, t0.os AS os_8, t0.initial AS initial_9, t0.active AS active_10, t0.can_register AS can_register_11, t0.did_register AS did_register_12, t0.salt_pass AS salt_pass_13, t0.salt_pass_expires_at AS salt_pass_expires_at_14, t0.token_expire_at AS token_expire_at_15, t0.firebase_expire_at AS firebase_expire_at_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.last_login AS last_login_19, t0.roles AS roles_20, t0.password AS password_21 FROM user t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
  "cee86f0d457cb54dc1f94fbff8128c13"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\ProductMix 190
App\Entity\ProductIndicatorAnswer 27
App\Entity\PdvIndicatorAnswer 13
App\Entity\ProductIndicator 10
App\Entity\ProductDirecCompetitionIndicatorAnswer 10
App\Entity\PdvIndicator 9
App\Entity\Product 5
App\Entity\ProductDirecCompetitionIndicator 3
App\Entity\ProductDirecCompetition 2
App\Entity\User 1
App\Entity\Pdv 1
App\Entity\Client 1