Query Metrics
7
Database Queries
7
Different statements
140.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.15 ms (85.00%) |
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 395574 396302 396885 397961 398542 401267 404076 405423 417258 425079 426105 428265 445551 453436 457642 458231 458723 462481 462994 463614 466865 473673 476861 484300 487495 507890 507906 516444 519253 530564 536913 555971 557262 567185 577899 584160 591940 596686 604155 613383 619970 621356 624021 625088 630149 639893 666369 680297 690672 698187 698471 715735 716920 716980 722084 726410 730524 737051 741938 748117 754226 758397 758874 761114 762067 762174 763424 764623 766494 767092 769101 769272 770590 771784 771916 772307 773356 776072 777336 777542 777820 779094 779255 779421 779620 780147 780323 781088 781244 781583 782786 785036 785918 787057 788383 789167 789345 790216 790526 793228 799700 800145 800252 800938 801678 802040 802173 804816 804978 809964 810167 810326 816712 816760 820087 823543 824643 825759 827784 827866 ] |
||||||||||||||||||||||||||||||
|
11.03 ms (7.87%) |
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 777820 781088 800252 790526 764623 741938 536913 466865 577899 591940 726410 453436 404076 816760 519253 666369 782786 780147 763424 771916 779620 788383 800938 804816 804978 396302 816712 823543 825759 820087 827866 827784 690672 715735 639893 613383 777542 785918 802173 781583 800145 801678 769272 772307 789167 762067 761114 769101 716920 781244 785036 787057 799700 810167 604155 473673 426105 463614 398542 824643 530564 557262 584160 680297 619970 596686 624021 630149 776072 758874 802040 754226 767092 748117 737051 777336 780323 793228 405423 779421 397961 417258 779094 789345 790216 476861 462994 458231 507906 395574 396885 487495 770590 810326 771784 773356 698187 698471 401267 428265 555971 567185 716980 425079 458723 779255 766494 730524 758397 762174 722084 809964 457642 507890 621356 625088 484300 445551 462481 516444 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.91%) |
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 395574 396302 396885 397961 398542 401267 404076 405423 417258 425079 426105 428265 445551 453436 457642 458231 458723 462481 462994 463614 466865 473673 476861 484300 487495 507890 507906 516444 519253 530564 536913 555971 557262 567185 577899 584160 591940 596686 604155 613383 619970 621356 624021 625088 630149 639893 666369 680297 690672 698187 698471 715735 716920 716980 722084 726410 730524 737051 741938 748117 754226 758397 758874 761114 762067 762174 763424 764623 766494 767092 769101 769272 770590 771784 771916 772307 773356 776072 777336 777542 777820 779094 779255 779421 779620 780147 780323 781088 781244 781583 782786 785036 785918 787057 788383 789167 789345 790216 790526 793228 799700 800145 800252 800938 801678 802040 802173 804816 804978 809964 810167 810326 816712 816760 820087 823543 824643 825759 827784 827866 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step sister sex"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step sister секс"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step sister секс"
]
|
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.