Query Metrics
7
Database Queries
7
Different statements
172.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.03 ms (85.37%) |
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 34296 34706 383188 384807 386350 390205 396357 407418 414813 422732 428184 428229 434838 443808 447967 448511 451463 452588 453893 458667 460272 465520 465610 474855 485076 485077 485080 485358 491929 494141 500197 503472 517001 517143 518139 519268 522377 522666 525746 533490 538926 546715 547927 552913 558909 563154 563220 563320 569056 569116 570765 585514 587779 588405 591270 598375 600223 600798 600883 605280 606124 606262 611317 612991 622372 627738 641464 644270 644271 664522 665260 667473 674152 674183 678837 681969 688594 689849 689898 695368 699675 702067 710826 718407 723693 734654 741607 744285 756222 759855 759890 760058 760788 770277 780728 789175 796752 799625 802435 802547 804219 809339 815110 815124 815332 815693 816010 816091 816266 816419 816427 816731 817840 818450 818652 819583 819662 824473 826938 ] |
||||||||||||||||||||||||||||||
|
14.85 ms (8.62%) |
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 552913 587779 503472 485358 422732 600883 465520 451463 815693 816091 819662 824473 816427 816731 818450 533490 563320 641464 606262 780728 802547 741607 759890 760058 744285 759855 760788 770277 804219 525746 689849 453893 383188 494141 588405 519268 570765 789175 448511 547927 598375 485080 460272 522377 485076 569116 569056 605280 465610 34296 434838 591270 443808 500197 815110 815124 816010 447967 474855 485077 563154 611317 622372 386350 458667 491929 384807 414813 452588 517143 522666 546715 558909 563220 664522 644271 600798 644270 407418 390205 428229 518139 517001 428184 34706 396357 816266 819583 826938 815332 816419 817840 818652 538926 667473 674183 678837 689898 695368 710826 674152 699675 718407 665260 681969 688594 702067 606124 585514 612991 600223 627738 799625 796752 802435 809339 723693 734654 756222 759378 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (1.91%) |
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 34296 34706 383188 384807 386350 390205 396357 407418 414813 422732 428184 428229 434838 443808 447967 448511 451463 452588 453893 458667 460272 465520 465610 474855 485076 485077 485080 485358 491929 494141 500197 503472 517001 517143 518139 519268 522377 522666 525746 533490 538926 546715 547927 552913 558909 563154 563220 563320 569056 569116 570765 585514 587779 588405 591270 598375 600223 600798 600883 605280 606124 606262 611317 612991 622372 627738 641464 644270 644271 664522 665260 667473 674152 674183 678837 681969 688594 689849 689898 695368 699675 702067 710826 718407 723693 734654 741607 744285 756222 759855 759890 760058 760788 770277 780728 789175 796752 799625 802435 802547 804219 809339 815110 815124 815332 815693 816010 816091 816266 816419 816427 816731 817840 818450 818652 819583 819662 824473 826938 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"secretary stockings"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секретарш чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.