Query Metrics
7
Database Queries
7
Different statements
202.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.37 ms (87.68%) |
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 197736 381882 382413 389351 389680 389842 390571 391614 391653 391703 392565 397937 398531 403317 403319 411341 411368 424325 424417 424476 439792 443387 443697 443795 443849 444100 444124 453091 454167 454260 454565 457438 460909 460926 462321 462489 465963 466127 466147 466251 466263 466279 466836 466840 467517 467543 470290 470304 470560 470612 470925 475919 476023 476272 476334 477933 477975 479055 479089 479122 479177 481929 484452 485392 485766 486821 486896 490883 493172 499077 505855 506142 510353 511524 511594 514366 514369 519585 520154 520872 522078 523165 523830 523842 526456 547920 549758 550222 550646 555100 555793 560380 562976 562989 567407 580029 591430 609188 610473 617638 686383 709528 721413 739927 741468 742389 742585 781659 781679 781682 781692 781694 782148 788823 794699 796252 802195 818924 820228 820280 ] |
||||||||||||||||||||||||||||||
|
15.64 ms (7.73%) |
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 391614 391703 476272 481929 466147 475919 514369 519585 511594 485766 493172 523842 470290 444100 562976 549758 520872 466251 820228 820280 818924 721413 709528 591430 609188 794699 781694 796252 741468 739927 742585 742389 781659 781679 781692 802195 197736 686383 781682 782148 424417 555100 547920 424476 462489 477975 443387 443795 454260 470304 389680 411368 443697 466840 403319 466279 510353 511524 523165 520154 466836 479055 439792 457438 465963 506142 523830 462321 390571 444124 454167 484452 486896 550222 562989 580029 550646 567407 555793 381882 391653 443849 453091 454565 389351 403317 460926 470612 476023 389842 398531 411341 460909 476334 479177 470925 479089 479122 499077 522078 526456 490883 397937 610473 788823 392565 424325 485392 477933 470560 505855 560380 617638 382413 466263 467543 466127 467517 486821 514366 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.35%) |
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 197736 381882 382413 389351 389680 389842 390571 391614 391653 391703 392565 397937 398531 403317 403319 411341 411368 424325 424417 424476 439792 443387 443697 443795 443849 444100 444124 453091 454167 454260 454565 457438 460909 460926 462321 462489 465963 466127 466147 466251 466263 466279 466836 466840 467517 467543 470290 470304 470560 470612 470925 475919 476023 476272 476334 477933 477975 479055 479089 479122 479177 481929 484452 485392 485766 486821 486896 490883 493172 499077 505855 506142 510353 511524 511594 514366 514369 519585 520154 520872 522078 523165 523830 523842 526456 547920 549758 550222 550646 555100 555793 560380 562976 562989 567407 580029 591430 609188 610473 617638 686383 709528 721413 739927 741468 742389 742585 781659 781679 781682 781692 781694 782148 788823 794699 796252 802195 818924 820228 820280 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature fuck russian"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature секс русск"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature секс русск"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.71%) |
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.