Query Metrics
7
Database Queries
7
Different statements
204.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.93 ms (86.88%) |
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 402673 409021 412517 413895 415392 416155 416901 420028 420078 420594 420597 420677 421801 422747 424809 426014 426944 427620 428242 431727 436246 443351 443440 445567 452980 453293 453517 453882 455322 455409 458256 461230 467645 470060 470218 471363 471865 476632 478841 478850 487046 495771 500862 505359 508836 512581 515611 517278 517934 519427 519871 520825 522409 522522 523668 524280 524532 525049 525267 525420 526635 531909 533729 542832 547650 551236 552404 555807 555836 569445 569623 571779 580711 588336 599111 600158 604643 619762 659984 678188 679653 683839 688680 721045 726954 757719 768357 768889 771249 771822 771948 771976 772157 772765 773235 774447 774796 778766 778784 780562 782113 783162 784599 786381 787197 788795 789352 790938 791281 792196 804070 804154 815067 815105 815122 818818 820443 820591 823124 827879 ] |
||||||||||||||||||||||||||||||
|
17.04 ms (8.32%) |
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 453293 461230 427620 470060 757719 555836 409021 413895 420028 523668 424809 774447 815067 659984 571779 588336 790938 791281 772765 771249 768889 782113 773235 416901 522522 533729 599111 788795 792196 778784 771948 804070 787197 412517 402673 421801 524280 815122 768357 815105 721045 683839 778766 772157 771976 771822 774796 784599 804154 453882 455409 542832 467645 827879 555807 455322 436246 520825 524532 526635 517934 517278 512581 415392 452980 458256 470218 525420 547650 569445 569623 688680 551236 580711 619762 726954 604643 445567 416155 426014 428242 420597 420078 471865 478841 453517 487046 476632 495771 679653 552404 426944 443351 443440 478850 519871 525049 515611 500862 508836 519427 525267 422747 431727 678188 600158 783162 786381 420677 420594 471363 522409 505359 820591 823124 820443 818818 780562 789352 531909 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.16%) |
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 402673 409021 412517 413895 415392 416155 416901 420028 420078 420594 420597 420677 421801 422747 424809 426014 426944 427620 428242 431727 436246 443351 443440 445567 452980 453293 453517 453882 455322 455409 458256 461230 467645 470060 470218 471363 471865 476632 478841 478850 487046 495771 500862 505359 508836 512581 515611 517278 517934 519427 519871 520825 522409 522522 523668 524280 524532 525049 525267 525420 526635 531909 533729 542832 547650 551236 552404 555807 555836 569445 569623 571779 580711 588336 599111 600158 604643 619762 659984 678188 679653 683839 688680 721045 726954 757719 768357 768889 771249 771822 771948 771976 772157 772765 773235 774447 774796 778766 778784 780562 782113 783162 784599 786381 787197 788795 789352 790938 791281 792196 804070 804154 815067 815105 815122 818818 820443 820591 823124 827879 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex pov beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс пов красивая"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.79%) |
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.