Query Metrics
7
Database Queries
7
Different statements
193.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.59 ms (86.62%) |
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 6710 99632 162721 188150 266183 291356 384419 388329 391099 391354 393430 397085 409573 409930 423299 430777 434155 493488 506339 510890 510936 518786 522614 530464 531929 534549 537777 539632 540533 554513 554892 558718 569205 572351 584400 592741 599716 600758 601468 604570 605256 607537 614292 616521 620225 621536 634766 634849 668480 680778 682276 698111 707308 709346 714620 716329 717665 718040 720105 720179 724632 728451 729923 730547 734461 735891 739608 740890 746634 750743 753057 754990 757288 757848 760714 760738 765915 768208 769834 770167 772769 774147 778774 779248 787870 788942 788946 789243 789489 789691 795731 799979 800529 801398 802208 803717 805704 805832 805978 807143 807609 812054 814541 815167 815283 817283 817447 819402 820117 820656 823176 823801 824181 824267 826520 826636 828035 828142 828370 828703 ] |
||||||||||||||||||||||||||||||
|
14.92 ms (7.71%) |
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 718040 720105 788942 795731 800529 592741 604570 621536 388329 537777 668480 717665 569205 616521 805832 430777 506339 518786 99632 162721 539632 682276 601468 803717 754990 769834 799979 724632 753057 760714 757848 709346 720179 789489 807143 730547 789243 789691 188150 728451 826636 828703 397085 409930 423299 802208 815283 534549 558718 787870 729923 812054 707308 778774 393430 820656 826520 817283 823176 815167 531929 554892 572351 599716 605256 779248 805978 734461 746634 757288 765915 805704 740890 739608 768208 614292 291356 510936 391354 434155 600758 510890 716329 680778 714620 634849 788946 409573 522614 607537 391099 820117 828370 540533 698111 584400 634766 770167 735891 750743 554513 620225 384419 266183 6710 493488 801398 807609 774147 760738 824267 824181 817447 823801 814541 819402 828035 828142 530464 772769 ] |
||||||||||||||||||||||||||||||
|
4.09 ms (2.11%) |
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 6710 99632 162721 188150 266183 291356 384419 388329 391099 391354 393430 397085 409573 409930 423299 430777 434155 493488 506339 510890 510936 518786 522614 530464 531929 534549 537777 539632 540533 554513 554892 558718 569205 572351 584400 592741 599716 600758 601468 604570 605256 607537 614292 616521 620225 621536 634766 634849 668480 680778 682276 698111 707308 709346 714620 716329 717665 718040 720105 720179 724632 728451 729923 730547 734461 735891 739608 740890 746634 750743 753057 754990 757288 757848 760714 760738 765915 768208 769834 770167 772769 774147 778774 779248 787870 788942 788946 789243 789489 789691 795731 799979 800529 801398 802208 803717 805704 805832 805978 807143 807609 812054 814541 815167 815283 817283 817447 819402 820117 820656 823176 823801 824181 824267 826520 826636 828035 828142 828370 828703 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"очкастая тетка"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"очкастая мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.72%) |
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.