Query Metrics
8
Database Queries
8
Different statements
3.06 ms
Query time
0
Invalid entities
9
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.48 ms |
SELECT d0_.company_name AS company_name_0, d0_.company_address AS company_address_1, d0_.company_inn AS company_inn_2, d0_.license AS license_3, d0_.license_date AS license_date_4, d0_.name AS name_5, d0_.activity AS activity_6, d0_.id AS id_7, d0_.code AS code_8, c1_.password AS password_9, c1_.receiver AS receiver_10, c1_.type AS type_11, c1_.ip AS ip_12, c1_.port AS port_13, c1_.full_name AS full_name_14, c1_.full_address AS full_address_15, c1_.work_time AS work_time_16, c1_.station AS station_17, c1_.city AS city_18, c1_.bus AS bus_19, c1_.metro AS metro_20, c1_.minibus AS minibus_21, c1_.point AS point_22, c1_.disabled_discounts AS disabled_discounts_23, c1_.id AS id_24, c1_.created AS created_25, c1_.modified AS modified_26, c1_.sort AS sort_27, c1_.activity AS activity_28, c1_.image AS image_29, c1_.single_file AS single_file_30, c1_.lis_id AS lis_id_31, d0_.type AS type_32, d0_.price_customer_id AS price_customer_id_33, d0_.main_customer_id AS main_customer_id_34 FROM domains d0_ LEFT JOIN customers c1_ ON d0_.main_customer_id = c1_.id WHERE (d0_.code = ?) AND d0_.type IN ('DEFAULT_DOMAIN', 'LPU_DOMAIN')
Parameters:
[
"dev.analizy.uz"
]
|
| 2 | 0.72 ms |
SELECT t0.first_lane AS first_lane_1, t0.counter AS counter_2, t0.title AS title_3, t0.caption AS caption_4, t0.definition AS definition_5, t0.varieties AS varieties_6, t0.diagnostic_and_examination AS diagnostic_and_examination_7, t0.sources AS sources_8, t0.tags AS tags_9, t0.warning_message AS warning_message_10, t0.after_warning AS after_warning_11, t0.last_lane AS last_lane_12, t0.symptom AS symptom_13, t0.activity AS activity_14, t0.code AS code_15, t0.id AS id_16, t0.created AS created_17, t0.modified AS modified_18 FROM posts t0 WHERE t0.activity = ? AND t0.symptom = ? AND t0.code = ? LIMIT 1
Parameters:
[ 1 0 "geograficheskiy-yazyk" ] |
| 3 | 0.21 ms |
"START TRANSACTION"
Parameters:
[] |
| 4 | 0.25 ms |
UPDATE posts SET counter = ? WHERE id = ?
Parameters:
[ 250 55 ] |
| 5 | 0.13 ms |
"COMMIT"
Parameters:
[] |
| 6 | 0.20 ms |
SELECT t0.title AS title_1, t0.description AS description_2, t0.h1 AS h1_3, t0.url AS url_4, t0.keywords AS keywords_5, t0.id AS id_6 FROM seo_template t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
"/diseases/geograficheskiy-yazyk"
]
|
| 7 | 0.35 ms |
SELECT t0.activity AS activity_1, t0.name AS name_2, t0.synonym_rus AS synonym_rus_3, t0.synonym_eng AS synonym_eng_4, t0.description AS description_5, t0.indications AS indications_6, t0.popular AS popular_7, t0.methods AS methods_8, t0.bms AS bms_9, t0.training AS training_10, t0.id AS id_11, t0.code AS code_12, t0.lis_id AS lis_id_13, t0.analysis_group_id AS analysis_group_id_14, t0.panel FROM analyses t0 INNER JOIN posts_analyses ON t0.id = posts_analyses.analyses_id WHERE posts_analyses.posts_id = ? AND t0.panel IN ('a', 'ap')
Parameters:
[
55
]
|
| 8 | 0.72 ms |
SELECT t0.first_lane AS first_lane_1, t0.counter AS counter_2, t0.title AS title_3, t0.caption AS caption_4, t0.definition AS definition_5, t0.varieties AS varieties_6, t0.diagnostic_and_examination AS diagnostic_and_examination_7, t0.sources AS sources_8, t0.tags AS tags_9, t0.warning_message AS warning_message_10, t0.after_warning AS after_warning_11, t0.last_lane AS last_lane_12, t0.symptom AS symptom_13, t0.activity AS activity_14, t0.code AS code_15, t0.id AS id_16, t0.created AS created_17, t0.modified AS modified_18 FROM posts t0 INNER JOIN posts_posts ON t0.id = posts_posts.posts_target WHERE posts_posts.posts_source = ?
Parameters:
[
55
]
|
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\Dictionaries\Posts | 6 |
| App\Entity\Customer | 2 |
| App\Entity\Abstracts\Domain | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Abstracts\Domain | No errors. |
| App\Entity\Customer | No errors. |
| App\Entity\Domain\DefaultDomain | No errors. |
| App\Entity\Domain\LPU | No errors. |
| App\Entity\Cashbox | No errors. |
| App\Entity\Discount | No errors. |
| App\Entity\Dictionaries\Posts | No errors. |
| App\Entity\Abstracts\Analyses | No errors. |
| App\Entity\Seo | No errors. |
| App\Entity\Dictionaries\AnalysisGroups | No errors. |
| App\Entity\Analyse | No errors. |
| App\Entity\Panel | No errors. |