Query Metrics
7
Database Queries
7
Different statements
191.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.94 ms (86.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 54149 382196 382839 409317 411998 412018 412492 414217 416855 420119 421350 429936 434532 448730 449954 451707 454435 454824 457263 463913 464310 464354 468026 474599 474688 479858 483131 483374 485479 485720 506141 510178 512102 513760 516487 523146 528439 530928 536702 536731 539456 544505 550396 551574 552075 557237 558061 558086 559348 563466 569187 571014 574644 583827 584745 591470 596301 600614 604031 605310 618964 619393 622137 629326 630068 631132 634559 636836 665038 666800 667974 668897 669130 671392 673462 676151 692502 696201 696937 701152 702749 705446 705467 714145 714191 717683 718241 718965 718997 719677 719876 721132 721675 723098 726620 726649 726661 726864 726998 731832 731846 736487 736623 740454 741981 745634 747420 753247 759540 765335 774009 781816 782778 785298 791918 792817 799622 802831 804178 808084 ] |
||||||||||||||||||||||||||||||
|
16.56 ms (8.65%) |
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 528439 512102 544505 551574 571014 605310 774009 726864 411998 474599 629326 420119 485720 449954 558061 464310 464354 457263 454435 451707 485479 510178 429936 483131 536702 536731 557237 583827 574644 559348 665038 717683 676151 705467 668897 714145 714191 721675 596301 630068 781816 726620 736623 726649 726661 745634 726998 696937 54149 539456 718965 667974 604031 634559 799622 747420 618964 723098 412018 804178 382839 434532 409317 414217 416855 550396 792817 412492 454824 474688 513760 523146 448730 584745 468026 479858 483374 558086 516487 463913 530928 569187 692502 701152 718241 718997 666800 669130 719677 719876 552075 563466 591470 619393 622137 636836 741981 736487 753247 740454 759540 631132 702749 705446 721132 382196 506141 421350 671392 673462 696201 600614 782778 791918 765335 785298 802831 808084 731832 731846 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.33%) |
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 54149 382196 382839 409317 411998 412018 412492 414217 416855 420119 421350 429936 434532 448730 449954 451707 454435 454824 457263 463913 464310 464354 468026 474599 474688 479858 483131 483374 485479 485720 506141 510178 512102 513760 516487 523146 528439 530928 536702 536731 539456 544505 550396 551574 552075 557237 558061 558086 559348 563466 569187 571014 574644 583827 584745 591470 596301 600614 604031 605310 618964 619393 622137 629326 630068 631132 634559 636836 665038 666800 667974 668897 669130 671392 673462 676151 692502 696201 696937 701152 702749 705446 705467 714145 714191 717683 718241 718965 718997 719677 719876 721132 721675 723098 726620 726649 726661 726864 726998 731832 731846 736487 736623 740454 741981 745634 747420 753247 759540 765335 774009 781816 782778 785298 791918 792817 799622 802831 804178 808084 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"natural tits casting"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральная натуральные сиськ без силикон кастинг"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.78%) |
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.