Query Metrics
7
Database Queries
7
Different statements
153.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.34 ms (82.40%) |
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 13258 14232 79388 148793 154410 382238 388028 396590 396706 396720 397992 398528 399633 400787 402876 404175 405043 406322 408238 409383 420695 421995 428122 438576 445439 447740 450309 451989 453134 453543 457240 459162 459249 459764 460194 460243 460689 463825 464018 464179 464371 464410 464426 465082 471814 477483 478676 482780 483588 486551 489373 503194 516842 517741 518836 523392 523418 529122 529441 531155 532708 536290 536357 536366 540437 542209 543852 543918 554927 565147 583982 585971 600252 600359 602534 604435 606501 607814 609991 613122 614993 616336 629868 631194 631690 634140 634528 637148 639334 639742 640798 646901 666582 673767 696983 697014 699756 712770 715555 721870 728738 729644 732292 742244 744651 756468 788283 788928 793662 800288 800296 802253 805110 805607 806225 810828 811826 811872 815279 825241 ] |
||||||||||||||||||||||||||||||
|
15.82 ms (10.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 613122 640798 800288 742244 438576 486551 607814 154410 453134 631690 744651 697014 409383 465082 532708 673767 696983 800296 788928 634528 463825 396720 616336 457240 811826 420695 477483 518836 536357 451989 602534 464371 529441 489373 540437 600252 464410 802253 715555 398528 523392 405043 428122 396590 388028 543852 503194 756468 460194 629868 408238 445439 600359 631194 404175 483588 543918 639742 400787 13258 464179 712770 536290 614993 453543 450309 634140 637148 382238 523418 531155 583982 639334 79388 460689 788283 646901 609991 604435 721870 402876 810828 399633 732292 14232 397992 459162 565147 447740 529122 811872 460243 396706 459764 464426 459249 815279 825241 517741 536366 542209 666582 806225 805607 729644 805110 728738 148793 478676 554927 606501 793662 516842 482780 471814 406322 421995 464018 585971 699756 ] |
||||||||||||||||||||||||||||||
|
3.71 ms (2.42%) |
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 13258 14232 79388 148793 154410 382238 388028 396590 396706 396720 397992 398528 399633 400787 402876 404175 405043 406322 408238 409383 420695 421995 428122 438576 445439 447740 450309 451989 453134 453543 457240 459162 459249 459764 460194 460243 460689 463825 464018 464179 464371 464410 464426 465082 471814 477483 478676 482780 483588 486551 489373 503194 516842 517741 518836 523392 523418 529122 529441 531155 532708 536290 536357 536366 540437 542209 543852 543918 554927 565147 583982 585971 600252 600359 602534 604435 606501 607814 609991 613122 614993 616336 629868 631194 631690 634140 634528 637148 639334 639742 640798 646901 666582 673767 696983 697014 699756 712770 715555 721870 728738 729644 732292 742244 744651 756468 788283 788928 793662 800288 800296 802253 805110 805607 806225 810828 811826 811872 815279 825241 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature blowjob bbc"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature минет оральн секс bbc"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature минет оральн секс bbc"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.