Query Metrics
7
Database Queries
7
Different statements
139.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.92 ms (83.83%) |
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 389935 390615 401367 403973 412721 414099 416174 416537 416539 424613 431439 442337 454368 454590 456117 466739 476656 476658 477506 498720 511858 524215 529617 529713 530402 531834 531877 532557 532634 533990 534447 534545 534563 535939 536129 540868 541533 545459 561019 564289 568501 573268 574375 574377 574391 580130 583472 585818 589185 592773 594619 609920 616454 624682 625780 628105 628106 647530 648704 648787 652786 653388 653602 660369 660380 662131 666857 667397 670360 671002 672952 686752 694401 700247 708577 715244 735703 739119 739805 740580 745295 748511 748519 749090 750426 751609 752646 752654 752679 752747 752932 754947 754994 758343 758508 758622 765559 770386 773040 780162 782998 785966 786888 788863 791039 791132 791920 792712 792726 796700 803551 804077 804663 806451 806834 806938 807252 807673 814140 814151 ] |
||||||||||||||||||||||||||||||
|
12.00 ms (8.60%) |
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 804663 791039 804077 807673 748519 754947 785966 806451 807252 498720 534447 424613 511858 585818 752646 532557 541533 666857 667397 786888 803551 780162 791920 752654 752932 758508 758622 773040 745295 748511 739805 752747 754994 765559 740580 782998 796700 401367 412721 431439 416174 414099 540868 476656 454590 534545 531834 531877 532634 529617 534563 536129 530402 574375 574377 583472 545459 561019 574391 660380 660369 670360 672952 715244 580130 592773 589185 594619 624682 628105 609920 616454 749090 806938 739119 750426 752679 735703 751609 758343 628106 788863 456117 403973 524215 573268 389935 466739 477506 625780 416539 416537 442337 814140 814151 476658 529713 568501 671002 648704 708577 564289 792726 770386 791132 792712 806834 390615 454368 533990 535939 648787 652786 653388 653602 662131 686752 694401 700247 647530 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (2.30%) |
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 389935 390615 401367 403973 412721 414099 416174 416537 416539 424613 431439 442337 454368 454590 456117 466739 476656 476658 477506 498720 511858 524215 529617 529713 530402 531834 531877 532557 532634 533990 534447 534545 534563 535939 536129 540868 541533 545459 561019 564289 568501 573268 574375 574377 574391 580130 583472 585818 589185 592773 594619 609920 616454 624682 625780 628105 628106 647530 648704 648787 652786 653388 653602 660369 660380 662131 666857 667397 670360 671002 672952 686752 694401 700247 708577 715244 735703 739119 739805 740580 745295 748511 748519 749090 750426 751609 752646 752654 752679 752747 752932 754947 754994 758343 758508 758622 765559 770386 773040 780162 782998 785966 786888 788863 791039 791132 791920 792712 792726 796700 803551 804077 804663 806451 806834 806938 807252 807673 814140 814151 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"home made dildo"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск дилд"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.13%) |
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.