Query Metrics
7
Database Queries
7
Different statements
173.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.41 ms (80.72%) |
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 542778 542992 543467 543733 546719 547980 550589 554541 558715 558801 560369 562779 564756 566366 566445 566475 566649 566866 566886 566892 566907 566927 566941 567395 568021 568187 568213 568259 568261 568262 568266 568304 571422 572173 575685 584250 586294 589659 590914 596336 598028 598597 599011 599577 600325 601166 602180 603468 603489 605329 614989 620554 621710 622361 622855 623826 623872 624159 624816 625761 627061 629265 630759 631255 631606 633161 634692 645895 646224 648285 648672 649615 649621 651078 651597 651684 651947 652240 652555 652983 653300 653450 654089 661899 666856 670062 670373 670388 671898 673497 673560 678433 679445 681797 681908 682822 685263 685728 687450 687466 688247 688248 690947 691171 691527 692008 692013 692023 692203 692440 692478 694034 694073 695685 696237 696250 706587 714609 714615 716590 ] |
||||||||||||||||||||||||||||||
|
12.84 ms (7.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 598028 623872 692478 566927 692203 620554 560369 562779 624159 571422 651947 673560 568187 603489 679445 631255 568021 670373 691171 598597 566907 600325 554541 646224 673497 631606 543733 691527 685263 714615 692008 575685 645895 688248 692440 648285 558715 566649 567395 572173 648672 678433 696237 692023 629265 568259 590914 566445 623826 653450 652555 688247 614989 624816 568262 566892 568261 621710 589659 690947 566475 596336 622855 630759 633161 547980 568213 543467 714609 568266 649615 692013 694034 671898 681908 627061 584250 695685 602180 681797 622361 670388 694073 550589 566866 566366 661899 685728 601166 564756 682822 654089 558801 586294 653300 652983 546719 625761 696250 649621 706587 566886 599011 651597 599577 634692 687466 687450 542778 568304 666856 603468 651078 652240 651684 716590 670062 566941 542992 605329 ] |
||||||||||||||||||||||||||||||
|
10.04 ms (5.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ретр любительск девушк"
]
|
||||||||||||||||||||||||||||||
|
5.48 ms (3.15%) |
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 542778 542992 543467 543733 546719 547980 550589 554541 558715 558801 560369 562779 564756 566366 566445 566475 566649 566866 566886 566892 566907 566927 566941 567395 568021 568187 568213 568259 568261 568262 568266 568304 571422 572173 575685 584250 586294 589659 590914 596336 598028 598597 599011 599577 600325 601166 602180 603468 603489 605329 614989 620554 621710 622361 622855 623826 623872 624159 624816 625761 627061 629265 630759 631255 631606 633161 634692 645895 646224 648285 648672 649615 649621 651078 651597 651684 651947 652240 652555 652983 653300 653450 654089 661899 666856 670062 670373 670388 671898 673497 673560 678433 679445 681797 681908 682822 685263 685728 687450 687466 688247 688248 690947 691171 691527 692008 692013 692023 692203 692440 692478 694034 694073 695685 696237 696250 706587 714609 714615 716590 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"retro amateur girls"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ретр любительск девушк"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.91%) |
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.