Query Metrics
7
Database Queries
7
Different statements
187.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.84 ms (83.60%) |
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 417212 421071 427346 430404 434601 446631 463780 466404 470613 472388 474509 481881 481904 481910 482507 484017 489328 491021 493180 495038 496118 502304 502512 508525 508673 510251 517923 520697 521135 522911 522914 522917 524969 534219 536695 536712 539351 541587 541588 541630 541631 541639 541650 541664 541673 541740 541759 541774 541821 541822 541864 541884 542199 542954 544800 550579 551069 556834 557558 569132 571434 574384 575661 576690 576713 583913 587901 600003 600022 601046 601324 604517 605521 606202 607355 607594 615909 616411 619407 623641 626347 628332 632595 632646 632680 632694 634178 634212 635243 636033 637092 639722 639790 641644 642746 643061 651607 652539 656303 665776 666850 676428 686843 699397 711283 770225 784152 788262 803455 807191 815383 ] |
||||||||||||||||||||||||||||||
|
20.80 ms (11.09%) |
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 784152 607355 632694 788262 510251 508525 502304 522917 430404 489328 541630 628332 521135 434601 463780 481904 522914 474509 541884 556834 557558 569132 575661 576690 576713 550579 571434 651607 665776 656303 606202 623641 601046 616411 634212 639790 641644 770225 632646 421071 472388 524969 574384 605521 466404 541650 496118 493180 446631 481910 534219 583913 541759 551069 699397 711283 615909 632680 643061 600003 637092 600022 807191 427346 417212 495038 491021 652539 539351 536695 481881 520697 502512 607594 470613 482507 517923 536712 541821 544800 626347 634178 632595 636033 803455 604517 541822 541587 542954 541673 541664 541740 541774 676428 686843 635243 587901 815383 541639 541588 666850 601324 508673 541631 484017 542199 541864 619407 639722 522911 642746 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.38%) |
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 417212 421071 427346 430404 434601 446631 463780 466404 470613 472388 474509 481881 481904 481910 482507 484017 489328 491021 493180 495038 496118 502304 502512 508525 508673 510251 517923 520697 521135 522911 522914 522917 524969 534219 536695 536712 539351 541587 541588 541630 541631 541639 541650 541664 541673 541740 541759 541774 541821 541822 541864 541884 542199 542954 544800 550579 551069 556834 557558 569132 571434 574384 575661 576690 576713 583913 587901 600003 600022 601046 601324 604517 605521 606202 607355 607594 615909 616411 619407 623641 626347 628332 632595 632646 632680 632694 634178 634212 635243 636033 637092 639722 639790 641644 642746 643061 651607 652539 656303 665776 666850 676428 686843 699397 711283 770225 784152 788262 803455 807191 815383 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature mom compilation"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature mom подборк"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature mom подборк"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.88%) |
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.