Query Metrics
7
Database Queries
7
Different statements
184.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.43 ms (87.02%) |
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 3381 327121 365992 381885 383320 385092 411257 415155 416859 417821 422511 425320 426433 434709 441004 444124 452618 454139 461443 463331 489355 489561 490862 491736 519778 541766 545717 546200 551223 552651 554288 561621 562373 565168 565174 565245 565491 566035 567766 567776 568324 570576 571217 578501 579358 583468 585390 593223 596501 596583 597239 598084 601475 601624 601644 602506 606540 628406 634115 635106 637094 637428 646838 648560 668099 675762 679016 702699 703101 707928 712582 714463 714480 716043 720033 720793 726327 727288 729815 731857 732681 744275 745678 746088 747368 747494 748338 752694 753441 753479 758951 758970 765326 765591 769748 769749 769778 771136 774652 775883 778380 778875 778938 779681 782375 784204 786012 786374 791175 794541 805347 810045 811863 813447 819211 820565 820839 823398 823490 827526 ] |
||||||||||||||||||||||||||||||
|
14.76 ms (8.01%) |
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 820565 752694 753479 745678 753441 746088 744275 782375 554288 567766 441004 784204 601624 668099 714480 596583 601475 416859 583468 561621 578501 731857 327121 635106 827526 716043 568324 565168 551223 546200 597239 422511 579358 565491 463331 3381 461443 411257 519778 769749 552651 791175 810045 727288 778875 778938 565245 566035 712582 707928 606540 381885 813447 365992 385092 545717 565174 585390 596501 646838 602506 628406 637094 593223 634115 769748 769778 823398 702699 765326 820839 823490 720793 774652 786012 786374 758951 794541 726327 748338 771136 747494 765591 729815 778380 779681 562373 775883 747368 679016 567776 571217 720033 714463 598084 601644 805347 732681 703101 811863 541766 383320 434709 444124 570576 415155 489561 758970 675762 454139 490862 426433 452618 489355 491736 819211 637428 425320 648560 417821 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.55%) |
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 3381 327121 365992 381885 383320 385092 411257 415155 416859 417821 422511 425320 426433 434709 441004 444124 452618 454139 461443 463331 489355 489561 490862 491736 519778 541766 545717 546200 551223 552651 554288 561621 562373 565168 565174 565245 565491 566035 567766 567776 568324 570576 571217 578501 579358 583468 585390 593223 596501 596583 597239 598084 601475 601624 601644 602506 606540 628406 634115 635106 637094 637428 646838 648560 668099 675762 679016 702699 703101 707928 712582 714463 714480 716043 720033 720793 726327 727288 729815 731857 732681 744275 745678 746088 747368 747494 748338 752694 753441 753479 758951 758970 765326 765591 769748 769749 769778 771136 774652 775883 778380 778875 778938 779681 782375 784204 786012 786374 791175 794541 805347 810045 811863 813447 819211 820565 820839 823398 823490 827526 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small anal sex"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая анал секс"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.70%) |
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.