Query Metrics
7
Database Queries
7
Different statements
147.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.36 ms (85.25%) |
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 102250 422259 442896 468363 483310 532306 533112 533317 535638 541187 542342 550365 556676 558648 579227 582902 586376 592280 592906 592908 592990 595232 601727 602050 603613 603847 604992 606251 607556 608039 618839 626027 628019 633018 633411 636265 636938 639041 639385 642045 642172 669634 670257 690250 710462 725538 734182 752012 760333 763644 764882 765393 766875 768162 768403 769426 775543 777575 778100 779047 781284 781344 783115 783425 789376 789402 791666 793867 794119 794554 794999 795559 795769 795941 796173 796262 796263 796357 796529 797176 798804 799442 800436 800652 801084 801528 801541 801792 802304 802330 802620 804810 807885 809227 809886 811184 811712 811747 812164 812805 813828 816704 817155 817399 817566 817569 818767 819427 821787 823751 823952 824381 824416 825263 825418 ] |
||||||||||||||||||||||||||||||
|
12.29 ms (8.36%) |
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 626027 633018 636938 595232 628019 633411 592280 592908 604992 639385 642172 752012 601727 602050 607556 535638 764517 606251 642045 789402 783425 769426 807885 603847 802620 483310 550365 556676 639041 825353 558648 669634 710462 579227 586376 618839 636265 592990 608039 603613 442896 422259 817569 821787 824381 817399 818767 819427 823751 813828 816704 817566 823952 817155 824416 825263 468363 582902 793867 794999 796173 800436 800652 809227 811747 777575 781344 794554 795559 796262 796357 797176 799442 801528 801541 802304 802330 804810 812805 783115 794119 795941 796529 801084 801792 811184 734182 760333 764454 764882 765393 766875 768403 769111 763644 763712 768162 778100 779047 781284 789376 791666 795769 796263 798804 809886 811712 812164 102250 532306 542342 670257 690250 592906 775543 725538 825418 533112 533317 541187 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.68%) |
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 102250 422259 442896 468363 483310 532306 533112 533317 535638 541187 542342 550365 556676 558648 579227 582902 586376 592280 592906 592908 592990 595232 601727 602050 603613 603847 604992 606251 607556 608039 618839 626027 628019 633018 633411 636265 636938 639041 639385 642045 642172 669634 670257 690250 710462 725538 734182 752012 760333 763644 764882 765393 766875 768162 768403 769426 775543 777575 778100 779047 781284 781344 783115 783425 789376 789402 791666 793867 794119 794554 794999 795559 795769 795941 796173 796262 796263 796357 796529 797176 798804 799442 800436 800652 801084 801528 801541 801792 802304 802330 802620 804810 807885 809227 809886 811184 811712 811747 812164 812805 813828 816704 817155 817399 817566 817569 818767 819427 821787 823751 823952 824381 824416 825263 825418 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade milf pov"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск milf пов"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск milf пов"
]
|
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.