Query Metrics
7
Database Queries
7
Different statements
166.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.26 ms (77.59%) |
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 286389 397027 416155 419515 423955 424926 425570 425719 425971 426926 429650 430324 443420 445755 449764 449809 451757 461346 463370 467896 469207 471997 473115 473868 480214 482254 483607 492234 493942 497458 499497 502607 504962 505585 507401 507540 512842 513825 515455 520704 520801 523040 523497 525372 532049 533191 534403 537517 548725 556561 562763 564704 566019 568368 570096 576935 585170 599002 600460 607202 613246 617964 621525 658810 660435 663754 675127 682914 712243 732791 757167 760181 760210 761343 771177 771182 771609 773319 775707 780706 780867 782916 784571 789523 789571 790008 790789 791686 792412 793883 794733 795143 795148 795717 797006 797262 799124 799394 804537 805392 805808 807154 809765 809889 812265 812669 812684 812841 813894 815075 816326 818009 819652 820783 821671 821691 822512 825775 826763 826878 ] |
||||||||||||||||||||||||||||||
|
28.13 ms (16.88%) |
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 821691 818009 471997 473868 512842 532049 523497 564704 566019 663754 617964 782916 784571 790789 804537 805392 807154 812669 780867 793883 795717 809765 809889 757167 761343 773319 805808 812841 732791 797006 799124 419515 445755 469207 424926 430324 443420 449764 449809 451757 467896 502607 520704 461346 621525 426926 482254 492234 520801 826878 483607 570096 760210 682914 675127 791686 425971 815075 820783 821671 819652 826763 816326 813894 822512 497458 505585 548725 556561 568368 576935 658810 712243 660435 613246 585170 789571 812684 775707 795143 795148 760181 790008 797262 771177 771609 771182 780706 792412 799394 812265 416155 480214 286389 423955 473115 499497 599002 504962 523040 513825 493942 507540 515455 825775 525372 600460 463370 562763 537517 397027 534403 607202 425570 425719 507401 533191 789523 794733 429650 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.45%) |
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 286389 397027 416155 419515 423955 424926 425570 425719 425971 426926 429650 430324 443420 445755 449764 449809 451757 461346 463370 467896 469207 471997 473115 473868 480214 482254 483607 492234 493942 497458 499497 502607 504962 505585 507401 507540 512842 513825 515455 520704 520801 523040 523497 525372 532049 533191 534403 537517 548725 556561 562763 564704 566019 568368 570096 576935 585170 599002 600460 607202 613246 617964 621525 658810 660435 663754 675127 682914 712243 732791 757167 760181 760210 761343 771177 771182 771609 773319 775707 780706 780867 782916 784571 789523 789571 790008 790789 791686 792412 793883 794733 795143 795148 795717 797006 797262 799124 799394 804537 805392 805808 807154 809765 809889 812265 812669 812684 812841 813894 815075 816326 818009 819652 820783 821671 821691 822512 825775 826763 826878 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov pussy lick"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов pussy лиза"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов pussy лиза"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.