Query Metrics
7
Database Queries
7
Different statements
169.64 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.80 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.18 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пары анал"
]
|
||||||||||||||||||||||||||||||
| 3 | 21.22 ms |
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 477058 553255 634487 790754 401500 528098 514805 555379 594353 535456 570208 597573 626617 652893 623206 621397 477125 488851 801749 565156 618477 621273 541923 517567 421323 526752 535282 502422 486183 537815 584712 593096 462381 591839 589698 614752 518996 433339 459857 558991 601903 636869 449123 402722 427550 531560 492525 559824 608037 495753 506801 576417 651929 598403 620100 624005 526107 484681 515793 527908 544123 556025 563546 596586 520496 526362 598466 743564 595369 617423 493249 623150 508725 585007 542187 491823 601963 447835 478672 522878 554392 553280 543374 604743 543874 550415 554425 528923 ] |
||||||||||||||||||||||||||||||
| 4 | 2.56 ms |
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 401500 402722 421323 427550 433339 447835 449123 459857 462381 477058 477125 478672 484681 486183 488851 491823 492525 493249 495753 502422 506801 508725 514805 515793 517567 518996 520496 522878 526107 526362 526752 527908 528098 528923 531560 535282 535456 537815 541923 542187 543374 543874 544123 550415 553255 553280 554392 554425 555379 556025 558991 559824 563546 565156 570208 576417 584712 585007 589698 591839 593096 594353 595369 596586 597573 598403 598466 601903 601963 604743 608037 614752 617423 618477 620100 621273 621397 623150 623206 624005 626617 634487 636869 651929 652893 743564 790754 801749 ] |
||||||||||||||||||||||||||||||
| 5 | 138.72 ms |
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 401500 402722 421323 427550 433339 447835 449123 459857 462381 477058 477125 478672 484681 486183 488851 491823 492525 493249 495753 502422 506801 508725 514805 515793 517567 518996 520496 522878 526107 526362 526752 527908 528098 528923 531560 535282 535456 537815 541923 542187 543374 543874 544123 550415 553255 553280 554392 554425 555379 556025 558991 559824 563546 565156 570208 576417 584712 585007 589698 591839 593096 594353 595369 596586 597573 598403 598466 601903 601963 604743 608037 614752 617423 618477 620100 621273 621397 623150 623206 624005 626617 634487 636869 651929 652893 743564 790754 801749 ] |
||||||||||||||||||||||||||||||
| 6 | 1.70 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пар анал"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.46 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пар анал"
]
|
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.