Query Metrics
7
Database Queries
7
Different statements
142.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.71 ms (81.99%) |
1 |
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id AND f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id` AND `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 307940 393697 402777 411228 414329 417428 421009 424098 425102 437582 438934 439899 445764 447090 447775 448842 450867 454462 454798 456302 457327 457877 457898 458111 458513 460997 461215 463381 464010 465122 467942 469931 471173 471409 472070 476029 477488 477516 477973 478609 479485 480895 485586 486710 487674 487775 488769 492225 492230 493483 494406 496083 497399 497485 498311 500314 502674 502756 506861 508744 509303 510138 510189 511999 514731 514978 515465 515522 515537 515632 515652 516369 516915 517370 517564 517772 517905 517957 519281 519736 520036 520793 521841 521890 521896 522302 522524 522766 523700 525328 526167 526289 526315 526505 526649 526770 526814 526945 527262 528092 528975 529769 531069 532652 535462 535473 577322 601650 641090 816723 816848 816859 818205 819100 819101 820044 820503 823894 825653 828728 ] |
||||||||||||||||||||||||||||||
|
15.27 ms (10.73%) |
1 |
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id` AND `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id` AND `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 439899 447090 447775 450867 454798 461215 465122 471173 472070 477516 477973 478609 402777 414329 424098 437582 445764 454462 457327 457877 457898 458513 460997 463381 464010 469931 479485 480895 417428 421009 425102 456302 458111 467942 471409 476029 477488 500314 506861 509303 511999 514731 515465 515632 516915 517905 519736 521890 521896 522524 522766 523700 526315 526770 526945 529769 492225 492230 496083 497485 502674 502756 510138 515522 515537 517370 517772 520036 522302 526649 527262 535473 486710 488769 494406 498311 514978 516369 517957 519281 521841 525328 526167 526505 531069 485586 487674 487775 493483 497399 508744 510189 515652 526289 528092 528975 535462 438934 448842 577322 601650 641090 307940 517564 520793 526814 393697 411228 816859 819100 816723 819101 816848 820044 823894 818205 820503 825653 828728 532652 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.88%) |
1 |
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 307940 393697 402777 411228 414329 417428 421009 424098 425102 437582 438934 439899 445764 447090 447775 448842 450867 454462 454798 456302 457327 457877 457898 458111 458513 460997 461215 463381 464010 465122 467942 469931 471173 471409 472070 476029 477488 477516 477973 478609 479485 480895 485586 486710 487674 487775 488769 492225 492230 493483 494406 496083 497399 497485 498311 500314 502674 502756 506861 508744 509303 510138 510189 511999 514731 514978 515465 515522 515537 515632 515652 516369 516915 517370 517564 517772 517905 517957 519281 519736 520036 520793 521841 521890 521896 522302 522524 522766 523700 525328 526167 526289 526315 526505 526649 526770 526814 526945 527262 528092 528975 529769 531069 532652 535462 535473 577322 601650 641090 816723 816848 816859 818205 819100 819101 820044 820503 823894 825653 828728 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"xxx sport"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.33%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"xxx спортивная"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"xxx спортивная"
]
|
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
No loaded entities.