Query Metrics
7
Database Queries
7
Different statements
201.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.06 ms (87.01%) |
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 21506 384808 400137 401159 402659 403031 414164 414177 415735 416385 417745 420101 422351 425682 427523 428159 428596 430397 433572 440691 443061 446126 446359 446900 447551 448859 451410 453785 454092 459499 459506 460450 460629 461591 461655 463298 465964 466022 466700 466781 466886 469171 473761 475876 480089 480885 483613 488561 494402 495588 499378 504578 506218 512826 513002 513098 514387 514388 518555 520421 521964 523182 523761 531907 538638 539699 542818 542831 543435 551202 556935 561077 561885 562265 562327 566170 566642 567735 571062 574490 575506 576368 576445 582944 583629 590123 594212 594518 594525 596161 597269 603108 624231 632169 635141 650160 652913 668533 678915 696949 712158 716118 720188 720211 723492 732681 743120 752164 758024 774178 776126 784256 784744 790501 803454 806668 811994 812364 820594 823519 ] |
||||||||||||||||||||||||||||||
|
16.07 ms (7.99%) |
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 635141 784256 784744 488561 446900 460629 454092 594518 806668 416385 400137 428159 523182 514388 463298 461591 414164 506218 543435 556935 561077 582944 696949 594212 594525 752164 774178 433572 443061 460450 414177 422351 499378 440691 415735 428596 430397 461655 448859 465964 466700 531907 542831 576445 551202 561885 562327 571062 575506 576368 542818 712158 678915 720211 562265 566642 567735 574490 590123 603108 596161 597269 776126 811994 812364 732681 743120 790501 758024 624231 720188 723492 803454 446126 473761 480885 425682 446359 459506 466781 469171 401159 420101 451410 403031 480089 417745 447551 459499 466022 475876 514387 520421 521964 494402 504578 513002 518555 523761 483613 512826 632169 513098 384808 21506 402659 427523 820594 823519 453785 466886 539699 538638 495588 566170 583629 650160 652913 668533 716118 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.29%) |
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 21506 384808 400137 401159 402659 403031 414164 414177 415735 416385 417745 420101 422351 425682 427523 428159 428596 430397 433572 440691 443061 446126 446359 446900 447551 448859 451410 453785 454092 459499 459506 460450 460629 461591 461655 463298 465964 466022 466700 466781 466886 469171 473761 475876 480089 480885 483613 488561 494402 495588 499378 504578 506218 512826 513002 513098 514387 514388 518555 520421 521964 523182 523761 531907 538638 539699 542818 542831 543435 551202 556935 561077 561885 562265 562327 566170 566642 567735 571062 574490 575506 576368 576445 582944 583629 590123 594212 594518 594525 596161 597269 603108 624231 632169 635141 650160 652913 668533 678915 696949 712158 716118 720188 720211 723492 732681 743120 752164 758024 774178 776126 784256 784744 790501 803454 806668 811994 812364 820594 823519 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot teen tits"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot teen сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot teen сиськ"
]
|
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.