Query Metrics
7
Database Queries
7
Different statements
146.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.32 ms (82.96%) |
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 393701 414688 414734 428966 430977 446600 447501 451528 454722 455211 466187 470773 471997 475965 478875 481311 482073 487207 489499 489597 489818 489856 497074 502115 503962 505952 508035 508830 511600 512129 513724 518053 525938 543750 546004 546715 548788 552647 556574 557981 558003 558844 561825 562208 563063 563188 563803 565947 565953 567335 568121 569134 569878 570031 570197 571893 573345 573557 573667 573814 574826 575503 575774 576062 576098 586493 586605 592071 596871 597066 598617 617340 619509 654317 654575 655671 658358 659394 671127 672466 676465 676529 677345 678541 678552 679044 679060 679062 679067 679350 679368 714432 722695 722730 722867 722888 722901 723421 730987 742181 744262 744441 745075 745381 751770 753360 753364 753418 753847 753870 755836 758987 760514 766242 769811 788717 811439 819963 824146 ] |
||||||||||||||||||||||||||||||
|
14.98 ms (10.24%) |
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 744262 503962 745075 447501 489499 819963 672466 744441 671127 597066 475965 576098 505952 518053 596871 760514 446600 576062 565953 574826 451528 562208 502115 393701 478875 487207 659394 561825 543750 730987 552647 679350 563063 430977 598617 570031 567335 676465 617340 679067 573557 714432 548788 569134 454722 654575 678541 753847 753364 753418 788717 481311 677345 753870 455211 573345 573667 428966 508830 766242 558003 676529 679062 722901 811439 753360 755836 722695 414688 466187 556574 654317 658358 569878 571893 563188 508035 570197 619509 546004 546715 568121 592071 586493 586605 511600 497074 679368 722867 678552 745381 769811 751770 723421 824146 672488 558844 563803 565947 573814 470773 512129 557981 482073 513724 575503 575774 489818 489597 471997 655671 525938 489856 679044 679060 722888 722730 758987 742181 414734 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.90%) |
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 393701 414688 414734 428966 430977 446600 447501 451528 454722 455211 466187 470773 471997 475965 478875 481311 482073 487207 489499 489597 489818 489856 497074 502115 503962 505952 508035 508830 511600 512129 513724 518053 525938 543750 546004 546715 548788 552647 556574 557981 558003 558844 561825 562208 563063 563188 563803 565947 565953 567335 568121 569134 569878 570031 570197 571893 573345 573557 573667 573814 574826 575503 575774 576062 576098 586493 586605 592071 596871 597066 598617 617340 619509 654317 654575 655671 658358 659394 671127 672466 676465 676529 677345 678541 678552 679044 679060 679062 679067 679350 679368 714432 722695 722730 722867 722888 722901 723421 730987 742181 744262 744441 745075 745381 751770 753360 753364 753418 753847 753870 755836 758987 760514 766242 769811 788717 811439 819963 824146 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русское худые куни"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск худые куннилингус оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.93%) |
1 |
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.