Query Metrics
7
Database Queries
7
Different statements
202.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.80 ms (87.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 4279 181304 181612 383715 383774 388887 389388 393833 395174 409045 409105 409933 410709 413947 417384 421408 421942 422043 423981 424261 425947 426316 427631 439668 450344 453218 453805 454478 455620 455885 456453 457569 459022 460308 460930 461060 463156 463403 464159 464202 464552 465351 465897 465906 466281 466324 466904 467525 468105 468180 469565 471619 472069 475377 476975 478121 478163 478247 478423 479023 482519 482723 482763 482907 484544 488023 488468 488603 491138 491830 491926 491975 491982 492003 492013 492616 493131 494943 496719 498598 499194 499331 499806 500377 501082 502737 503491 503682 505702 509234 512500 512636 514844 515694 515855 520490 520501 520640 520819 521166 522122 522578 522849 522953 527362 528112 528733 531278 531524 535758 665042 675725 747296 755462 762611 811489 815683 815793 828644 828845 ] |
||||||||||||||||||||||||||||||
|
14.70 ms (7.27%) |
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 466324 409045 512636 496719 494943 500377 463403 482723 665042 383715 488468 499331 460308 482763 482907 478121 409933 521166 475377 466281 478163 515855 528112 453805 476975 393833 675725 491830 459022 747296 413947 389388 425947 464552 454478 181304 181612 410709 422043 426316 450344 469565 455620 453218 465897 488603 509234 505702 466904 472069 463156 465906 468180 383774 456453 395174 465351 468105 491982 503682 491926 491975 492013 520490 520640 815683 815793 828845 828644 514844 762611 811489 755462 488023 421408 484544 528733 461060 4279 388887 493131 520501 423981 535758 421942 427631 417384 457569 464202 502737 515694 522849 499806 478423 409105 455885 478247 460930 464159 479023 503491 522953 522122 527362 492616 501082 522578 491138 492003 499194 482519 531278 531524 498598 512500 520819 471619 424261 439668 467525 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (1.64%) |
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 4279 181304 181612 383715 383774 388887 389388 393833 395174 409045 409105 409933 410709 413947 417384 421408 421942 422043 423981 424261 425947 426316 427631 439668 450344 453218 453805 454478 455620 455885 456453 457569 459022 460308 460930 461060 463156 463403 464159 464202 464552 465351 465897 465906 466281 466324 466904 467525 468105 468180 469565 471619 472069 475377 476975 478121 478163 478247 478423 479023 482519 482723 482763 482907 484544 488023 488468 488603 491138 491830 491926 491975 491982 492003 492013 492616 493131 494943 496719 498598 499194 499331 499806 500377 501082 502737 503491 503682 505702 509234 512500 512636 514844 515694 515855 520490 520501 520640 520819 521166 522122 522578 522849 522953 527362 528112 528733 531278 531524 535758 665042 675725 747296 755462 762611 811489 815683 815793 828644 828845 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"white stockings"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"white чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"white чулк нижн бел"
]
|
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.