Query Metrics
7
Database Queries
7
Different statements
238.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
216.42 ms (90.61%) |
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 383148 411884 417242 417832 421760 422203 423516 426393 428580 432625 440817 441511 441570 441583 441597 441921 442080 443906 452327 454926 461081 463934 464778 464853 465550 466224 468073 477110 482191 489849 491584 493606 493676 493758 494927 495811 500963 501708 503256 505843 506097 511431 511672 513626 515974 523338 527850 533246 536366 544870 544945 558777 567562 579840 582563 589314 598088 599153 605681 612960 624196 625708 635558 665929 670753 675188 693208 709654 728738 731254 731328 733677 735353 742719 758027 759369 761050 761754 765374 765397 765400 765643 765729 765804 766658 766779 767172 778670 780799 783425 786195 788171 788450 788928 789496 791403 791419 791784 792649 793951 796497 798929 800623 801542 801550 802620 807133 807352 807402 812722 812929 812936 815115 815140 815480 817747 820586 823514 826626 826650 ] |
||||||||||||||||||||||||||||||
|
12.75 ms (5.34%) |
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 759369 765400 765804 766779 780799 788450 801542 807402 441597 493606 494927 421760 411884 815115 442080 423516 440817 464853 489849 463934 491584 493758 503256 506097 511431 567562 675188 544945 579840 624196 598088 599153 807352 812929 731328 778670 798929 461081 465550 443906 477110 495811 612960 533246 693208 735353 742719 426393 441921 441583 428580 432625 817747 464778 493676 466224 468073 511672 536366 635558 625708 783425 792649 765397 728738 765374 802620 383148 500963 527850 501708 731254 709654 515974 482191 452327 422203 513626 505843 454926 793951 417242 441570 826650 826626 815480 820586 815140 823514 523338 544870 558777 670753 605681 589314 786195 788171 791784 796497 789496 800623 812936 758027 761754 767172 788928 791403 791419 766658 733677 765643 761050 765729 801550 812722 417832 582563 665929 807133 441511 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.23%) |
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 383148 411884 417242 417832 421760 422203 423516 426393 428580 432625 440817 441511 441570 441583 441597 441921 442080 443906 452327 454926 461081 463934 464778 464853 465550 466224 468073 477110 482191 489849 491584 493606 493676 493758 494927 495811 500963 501708 503256 505843 506097 511431 511672 513626 515974 523338 527850 533246 536366 544870 544945 558777 567562 579840 582563 589314 598088 599153 605681 612960 624196 625708 635558 665929 670753 675188 693208 709654 728738 731254 731328 733677 735353 742719 758027 759369 761050 761754 765374 765397 765400 765643 765729 765804 766658 766779 767172 778670 780799 783425 786195 788171 788450 788928 789496 791403 791419 791784 792649 793951 796497 798929 800623 801542 801550 802620 807133 807352 807402 812722 812929 812936 815115 815140 815480 817747 820586 823514 826626 826650 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal pov mature"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.74%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал пов mature"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.67%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал пов mature"
]
|
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.