Query Metrics
7
Database Queries
7
Different statements
169.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.79 ms (82.13%) |
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 25030 32874 33401 37057 96342 111339 126637 379330 382788 384541 385373 386758 386840 388094 389978 390318 395504 396594 397958 398528 401115 414088 415872 419126 446340 446345 446352 446698 449592 464344 477801 478498 483576 485161 489276 516666 516750 516770 517605 528875 530729 530911 534986 534993 535083 535816 536309 536578 537837 544694 545359 552951 553282 561265 565104 566656 568543 573934 587928 591893 599957 604588 605449 613079 617429 623964 629279 630873 633972 637785 640723 643934 644246 665361 673767 673776 684106 686034 687594 692495 693153 693219 694476 694908 700678 712887 714830 715068 715551 719955 720015 720025 720061 721065 722187 723376 725171 732888 738241 742428 744656 745037 746837 749152 750884 789187 797387 806121 810355 810709 813799 814661 814667 817786 820849 821698 822279 822888 822990 824900 ] |
||||||||||||||||||||||||||||||
|
17.94 ms (10.62%) |
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 566656 591893 446698 386758 587928 599957 749152 385373 379330 25030 389978 396594 820849 478498 489276 537837 565104 673776 720061 694908 623964 644246 746837 797387 806121 604588 637785 390318 384541 126637 822888 822990 821698 822279 535083 517605 528875 536578 561265 573934 665361 692495 684106 693219 720015 687594 694476 715068 629279 630873 643934 738241 810355 750884 732888 700678 719955 789187 96342 446340 530729 530911 534986 534993 516750 553282 568543 640723 617429 516770 386840 111339 37057 32874 388094 419126 414088 415872 817786 813799 814661 814667 824900 446345 477801 483576 536309 535816 464344 544694 552951 545359 673767 686034 720025 721065 723376 693153 712887 722187 613079 725171 745037 744656 714830 715551 810709 446352 395504 401115 33401 382788 397958 398528 485161 449592 516666 633972 742428 605449 ] |
||||||||||||||||||||||||||||||
|
4.08 ms (2.41%) |
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 25030 32874 33401 37057 96342 111339 126637 379330 382788 384541 385373 386758 386840 388094 389978 390318 395504 396594 397958 398528 401115 414088 415872 419126 446340 446345 446352 446698 449592 464344 477801 478498 483576 485161 489276 516666 516750 516770 517605 528875 530729 530911 534986 534993 535083 535816 536309 536578 537837 544694 545359 552951 553282 561265 565104 566656 568543 573934 587928 591893 599957 604588 605449 613079 617429 623964 629279 630873 633972 637785 640723 643934 644246 665361 673767 673776 684106 686034 687594 692495 693153 693219 694476 694908 700678 712887 714830 715068 715551 719955 720015 720025 720061 721065 722187 723376 725171 732888 738241 742428 744656 745037 746837 749152 750884 789187 797387 806121 810355 810709 813799 814661 814667 817786 820849 821698 822279 822888 822990 824900 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black cock bbc"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black cock bbc"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black cock bbc"
]
|
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.