Query Metrics
7
Database Queries
7
Different statements
160.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.08 ms (84.18%) |
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 430088 431516 432786 441229 445279 445639 451574 453670 454367 472785 473392 477496 482147 486336 489973 491671 500909 508053 511702 513265 516644 518237 526125 530792 531200 537198 537936 540334 543850 543867 545418 559178 573211 574269 577215 581427 586886 586890 591170 601803 603273 604890 611307 630552 637098 641705 651003 661285 670562 672383 673578 676095 679798 680202 683301 684554 684567 699631 703436 705540 705906 707333 708110 710668 715682 719841 720112 720127 720340 720394 724230 724304 725599 726290 728271 731775 732004 733246 733866 742684 745896 746980 746994 748528 749332 757544 761167 761425 767287 768186 769924 770141 770293 770322 770787 775492 775879 780637 781300 788973 789521 790382 792515 792831 794230 794824 801472 801927 801934 801950 802001 805600 809574 814037 814320 815875 817444 817451 818160 823920 ] |
||||||||||||||||||||||||||||||
|
14.18 ms (8.84%) |
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 724304 761167 761425 767287 790382 792831 802001 732004 757544 770787 726290 728271 731775 749332 770322 703436 705906 780637 801927 805600 586886 630552 432786 672383 586890 477496 526125 473392 431516 817444 814320 823920 814037 591170 775492 801950 788973 792515 801472 801934 745896 769924 770293 781300 794824 733246 742684 768186 770141 775879 789521 794230 453670 491671 445279 454367 489973 543850 543867 601803 724230 511702 574269 486336 817451 540334 516644 530792 710668 699631 707333 715682 719841 720127 651003 708110 603273 746980 748528 725599 733866 746994 637098 809574 482147 445639 451574 441229 472785 500909 508053 513265 518237 577215 604890 545418 559178 537198 430088 818160 815875 531200 537936 573211 680202 683301 720340 673578 676095 679798 720112 661285 670562 684554 684567 705540 720394 581427 611307 641705 ] |
||||||||||||||||||||||||||||||
|
3.48 ms (2.17%) |
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 430088 431516 432786 441229 445279 445639 451574 453670 454367 472785 473392 477496 482147 486336 489973 491671 500909 508053 511702 513265 516644 518237 526125 530792 531200 537198 537936 540334 543850 543867 545418 559178 573211 574269 577215 581427 586886 586890 591170 601803 603273 604890 611307 630552 637098 641705 651003 661285 670562 672383 673578 676095 679798 680202 683301 684554 684567 699631 703436 705540 705906 707333 708110 710668 715682 719841 720112 720127 720340 720394 724230 724304 725599 726290 728271 731775 732004 733246 733866 742684 745896 746980 746994 748528 749332 757544 761167 761425 767287 768186 769924 770141 770293 770322 770787 775492 775879 780637 781300 788973 789521 790382 792515 792831 794230 794824 801472 801927 801934 801950 802001 805600 809574 814037 814320 815875 817444 817451 818160 823920 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"handjob double"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк член double"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дрочк член double"
]
|
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.