Query Metrics
7
Database Queries
7
Different statements
185.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.99 ms (86.19%) |
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 13011 13258 79388 154374 191487 249637 331119 381752 383075 383326 384803 388028 388774 390180 396609 396720 396722 397781 397849 399089 400787 401203 405848 407429 411684 416063 417050 421761 426249 449868 450241 453134 456902 460194 466499 466968 468483 474852 480929 485354 485795 486788 496329 499274 499556 511844 515698 515777 516021 516686 517610 529202 529286 532926 533196 533529 535749 537840 540528 548568 548575 556428 558074 558440 563478 573230 575020 584214 589576 589674 603387 604083 604574 604597 604610 604905 607459 620147 630194 632681 640798 644309 651601 663895 666584 666850 669771 675008 675010 681257 681301 681596 690786 712788 715533 719004 721060 721830 725451 725633 726165 726665 731888 732292 735942 738821 740903 742880 744624 744654 745245 773796 775202 789692 790814 795515 804758 807641 811826 817351 ] |
||||||||||||||||||||||||||||||
|
16.41 ms (8.84%) |
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 731888 735942 773796 384803 515777 396609 449868 529286 383075 191487 397849 405848 474852 663895 589576 604083 604597 249637 516686 589674 480929 388774 397781 517610 499274 499556 540528 584214 548575 690786 644309 607459 775202 740903 795515 726165 732292 738821 630194 721060 804758 675010 651601 558440 811826 154374 13011 407429 817351 453134 466499 485795 496329 537840 548568 563478 669771 666584 681596 712788 719004 604905 620147 640798 725633 742880 745245 807641 726665 744654 604610 715533 790814 460194 485354 558074 529202 331119 79388 396722 416063 450241 456902 468483 532926 515698 533529 535749 533196 556428 573230 575020 681257 721830 603387 632681 725451 744624 789692 388028 399089 400787 396720 13258 390180 401203 466968 681301 516021 511844 666850 675008 381752 486788 604574 383326 421761 426249 411684 417050 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.59%) |
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 13011 13258 79388 154374 191487 249637 331119 381752 383075 383326 384803 388028 388774 390180 396609 396720 396722 397781 397849 399089 400787 401203 405848 407429 411684 416063 417050 421761 426249 449868 450241 453134 456902 460194 466499 466968 468483 474852 480929 485354 485795 486788 496329 499274 499556 511844 515698 515777 516021 516686 517610 529202 529286 532926 533196 533529 535749 537840 540528 548568 548575 556428 558074 558440 563478 573230 575020 584214 589576 589674 603387 604083 604574 604597 604610 604905 607459 620147 630194 632681 640798 644309 651601 663895 666584 666850 669771 675008 675010 681257 681301 681596 690786 712788 715533 719004 721060 721830 725451 725633 726165 726665 731888 732292 735942 738821 740903 742880 744624 744654 745245 773796 775202 789692 790814 795515 804758 807641 811826 817351 ] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black cock mature"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black cock mature"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black cock mature"
]
|
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.