Query Metrics
7
Database Queries
7
Different statements
178.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.52 ms (84.14%) |
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 96297 223442 414374 419560 429768 438057 451866 461723 463122 467106 483049 513215 515223 517788 518464 522886 522977 530020 531136 531205 532662 534090 534149 534842 536538 537894 541853 541863 543669 543757 545368 545698 551065 552070 554301 556600 556939 560450 562823 565154 565262 565351 566786 570683 580290 586770 594431 595825 600014 604902 613146 613163 628374 630635 630764 631166 631209 632628 632663 632803 634478 637100 642025 643020 645207 645919 647994 651028 651178 652829 659072 662020 664963 666728 670038 670051 674101 674105 678117 683272 688345 691253 692208 696331 705514 709421 714007 715543 716564 716715 716887 717161 718974 722218 731053 731805 731816 732944 748219 748254 748470 749072 775786 775841 775854 775859 775968 788182 789669 794817 796431 799411 802794 811361 818520 818545 819493 823926 823943 ] |
||||||||||||||||||||||||||||||
|
17.52 ms (9.80%) |
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 652829 518464 513215 531205 565262 461723 429768 537894 562823 580290 647994 613146 637100 716887 451866 554301 632628 414374 691253 438057 688345 532662 556600 565351 483049 789669 775968 96297 709421 818520 530020 522886 541863 545368 565154 645207 534842 594431 642025 628374 674101 775859 463122 531136 678117 545698 631209 632663 666728 715543 664963 748254 560450 419560 748470 731816 586770 819493 775854 802794 732944 823943 794817 651178 722218 651028 775786 692208 659072 570683 632803 631166 799411 566786 662020 600014 643020 522977 517788 731053 534090 604902 543757 630635 630764 818545 551065 552070 543669 674105 717161 645919 556939 634478 748219 796431 534149 705514 541853 536538 670038 716715 696331 714007 775841 811361 515223 718974 683272 223442 823926 716564 595825 749072 788182 467106 670051 731805 613163 828531 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (1.77%) |
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 96297 223442 414374 419560 429768 438057 451866 461723 463122 467106 483049 513215 515223 517788 518464 522886 522977 530020 531136 531205 532662 534090 534149 534842 536538 537894 541853 541863 543669 543757 545368 545698 551065 552070 554301 556600 556939 560450 562823 565154 565262 565351 566786 570683 580290 586770 594431 595825 600014 604902 613146 613163 628374 630635 630764 631166 631209 632628 632663 632803 634478 637100 642025 643020 645207 645919 647994 651028 651178 652829 659072 662020 664963 666728 670038 670051 674101 674105 678117 683272 688345 691253 692208 696331 705514 709421 714007 715543 716564 716715 716887 717161 718974 722218 731053 731805 731816 732944 748219 748254 748470 749072 775786 775841 775854 775859 775968 788182 789669 794817 796431 799411 802794 811361 818520 818545 819493 823926 823943 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие сиськ gangbang"
]
|
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.