Query Metrics
7
Database Queries
7
Different statements
151.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.32 ms (82.63%) |
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 391059 391944 400928 414103 417553 419218 423980 424283 426962 427267 445745 447464 448089 448263 451100 453164 453731 461870 463034 466405 466553 467778 482494 493402 494575 499964 501960 506787 514660 515994 516936 519505 520174 527905 529293 532482 541216 549864 576005 579178 582277 590088 591940 593105 599538 600779 602146 604651 614671 620757 624201 624204 624207 625208 626616 675084 675461 681514 699554 700915 714927 726320 727459 728924 730722 730803 733217 733271 734283 740070 741577 742747 747431 747474 750729 751178 755138 758787 772360 780419 781962 786880 788132 790817 792348 793837 793841 794488 796307 796372 796480 800017 801164 801922 802716 803599 808021 808290 808691 815196 816397 819338 820022 823175 823598 823689 823754 823860 824077 824085 824509 824598 824645 824790 825260 826651 826739 827377 ] |
||||||||||||||||||||||||||||||
|
15.74 ms (10.38%) |
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 593105 602146 808691 482494 516936 579178 600779 499964 675084 742747 815196 599538 576005 591940 424283 453164 796372 391059 532482 614671 467778 788132 604651 391944 730722 419218 451100 453731 758787 423980 493402 461870 448263 549864 780419 519505 400928 414103 466405 426962 515994 541216 520174 506787 501960 590088 445745 463034 447464 514660 527905 699554 582277 681514 529293 626616 620757 824790 790817 819419 823754 824645 819338 824077 796307 730803 826651 823860 800017 772360 728924 824598 801164 727459 427267 417553 827377 792348 733271 494575 747431 786880 808021 624207 726320 823689 823598 803599 823175 824085 816397 751178 826739 700915 793837 741577 747474 714927 794488 625208 624201 624204 820022 734283 755138 802716 750729 733217 448089 466553 828594 740070 793841 808290 824509 825260 675461 796480 801922 781962 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.95%) |
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 391059 391944 400928 414103 417553 419218 423980 424283 426962 427267 445745 447464 448089 448263 451100 453164 453731 461870 463034 466405 466553 467778 482494 493402 494575 499964 501960 506787 514660 515994 516936 519505 520174 527905 529293 532482 541216 549864 576005 579178 582277 590088 591940 593105 599538 600779 602146 604651 614671 620757 624201 624204 624207 625208 626616 675084 675461 681514 699554 700915 714927 726320 727459 728924 730722 730803 733217 733271 734283 740070 741577 742747 747431 747474 750729 751178 755138 758787 772360 780419 781962 786880 788132 790817 792348 793837 793841 794488 796307 796372 796480 800017 801164 801922 802716 803599 808021 808290 808691 815196 816397 819338 820022 823175 823598 823689 823754 823860 824077 824085 824509 824598 824645 824790 825260 826651 826739 827377 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy and ass"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy жоп"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy жоп"
]
|
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.