Query Metrics
7
Database Queries
7
Different statements
173.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.53 ms (84.28%) |
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 6643 382401 388765 408432 422365 425309 428218 434281 435788 451503 451692 452355 452948 454018 454019 454429 456214 459352 459407 459421 459425 461782 462654 463509 471707 472663 478015 480031 482309 483512 489144 489926 492209 495490 496003 500616 504018 505727 506520 506822 506883 508708 509883 511246 511429 513115 518197 518371 522632 523649 526682 527448 528362 530127 538725 539644 542778 543355 546467 563648 565640 568132 568205 569058 569102 578780 580910 585989 587156 587161 587210 587212 587649 591060 593844 594143 594209 594254 594257 605055 612467 618401 624421 634826 650134 664584 673858 679198 706136 707518 710771 711590 714868 715114 715290 716790 720077 726956 735042 735867 742757 746358 748160 748609 754124 756259 757550 760058 763515 772759 781861 783415 784557 786113 787754 799212 799491 804861 806869 813649 ] |
||||||||||||||||||||||||||||||
|
16.88 ms (9.71%) |
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 506520 528362 511246 530127 504018 523649 542778 568132 543355 546467 565640 580910 673858 715114 715290 650134 664584 679198 706136 710771 714868 707518 716790 568205 569058 578780 593844 587212 587649 591060 594254 618401 587161 587210 605055 624421 585989 587156 594143 594209 594257 634826 787754 781861 748160 754124 772759 804861 748609 756259 757550 726956 735042 742757 746358 760058 735867 763515 711590 720077 783415 784557 786113 799212 799491 806869 408432 454018 459407 472663 434281 456214 382401 452355 478015 388765 422365 461782 471707 425309 522632 505727 492209 6643 612467 428218 435788 813649 451503 454019 489926 451692 452948 454429 459352 459421 459425 480031 489144 500616 506822 508708 509883 511429 539644 496003 518197 526682 495490 506883 518371 527448 538725 513115 462654 463509 482309 483512 563648 569102 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.80%) |
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 6643 382401 388765 408432 422365 425309 428218 434281 435788 451503 451692 452355 452948 454018 454019 454429 456214 459352 459407 459421 459425 461782 462654 463509 471707 472663 478015 480031 482309 483512 489144 489926 492209 495490 496003 500616 504018 505727 506520 506822 506883 508708 509883 511246 511429 513115 518197 518371 522632 523649 526682 527448 528362 530127 538725 539644 542778 543355 546467 563648 565640 568132 568205 569058 569102 578780 580910 585989 587156 587161 587210 587212 587649 591060 593844 594143 594209 594254 594257 605055 612467 618401 624421 634826 650134 664584 673858 679198 706136 707518 710771 711590 714868 715114 715290 716790 720077 726956 735042 735867 742757 746358 748160 748609 754124 756259 757550 760058 763515 772759 781861 783415 784557 786113 787754 799212 799491 804861 806869 813649 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"busty homemade"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"busty домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"busty домашн любительск"
]
|
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.