Query Metrics
7
Database Queries
7
Different statements
186.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.39 ms (85.26%) |
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 7172 366037 385070 396010 398342 398959 411197 411365 415935 417384 418830 421849 421855 422186 426316 432637 432678 432744 433356 439268 440489 443146 443897 443900 444346 444661 447844 455995 456078 457826 458459 461282 461767 463810 463926 464159 464346 465154 465527 466374 467961 468180 469927 470411 474583 475825 478423 482514 484313 485133 490863 491926 499942 503256 503301 505267 510074 512941 515821 516284 519530 535452 536432 545822 564546 567562 575578 586594 586644 590506 592621 593664 604333 620851 637758 657879 695559 705180 706535 714033 716857 717677 717974 731471 734324 743510 744968 744970 749684 756845 757726 761048 771335 778091 778282 779679 779744 788851 788980 789450 790191 794294 794854 795569 798987 802065 809648 817279 820861 821182 821191 821204 821392 821607 821956 822363 823049 825273 826176 828065 ] |
||||||||||||||||||||||||||||||
|
16.76 ms (8.96%) |
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 695559 705180 706535 717677 604333 779744 788851 778091 788980 802065 756845 734324 744970 761048 743510 757726 771335 731471 749684 809648 461767 458459 421849 422186 432637 484313 790191 465527 411197 637758 439268 443900 455995 443897 564546 426316 744968 398959 468180 418830 411365 456078 475825 491926 512941 620851 519530 385070 590506 717974 482514 510074 485133 586594 535452 432744 433356 432678 415935 474583 457826 463810 470411 516284 464346 593664 444661 421855 469927 463926 465154 467961 490863 499942 515821 503301 503256 536432 567562 794854 592621 447844 444346 396010 466374 545822 826176 828065 398342 443146 417384 478423 716857 366037 464159 461282 440489 586644 505267 7172 820861 821191 822363 817279 821607 821956 821392 823049 825273 821182 821204 575578 657879 714033 778282 789450 794294 798987 779679 795569 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (1.69%) |
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 7172 366037 385070 396010 398342 398959 411197 411365 415935 417384 418830 421849 421855 422186 426316 432637 432678 432744 433356 439268 440489 443146 443897 443900 444346 444661 447844 455995 456078 457826 458459 461282 461767 463810 463926 464159 464346 465154 465527 466374 467961 468180 469927 470411 474583 475825 478423 482514 484313 485133 490863 491926 499942 503256 503301 505267 510074 512941 515821 516284 519530 535452 536432 545822 564546 567562 575578 586594 586644 590506 592621 593664 604333 620851 637758 657879 695559 705180 706535 714033 716857 717677 717974 731471 734324 743510 744968 744970 749684 756845 757726 761048 771335 778091 778282 779679 779744 788851 788980 789450 790191 794294 794854 795569 798987 802065 809648 817279 820861 821182 821191 821204 821392 821607 821956 822363 823049 825273 826176 828065 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal in panties"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.75%) |
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.