Query Metrics
7
Database Queries
7
Different statements
146.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.73 ms (81.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 391496 391947 402887 402892 410251 412158 414646 417939 424518 424624 427129 428779 432897 436418 438982 439055 441811 441923 446200 455366 455597 456486 462830 462957 469271 469906 472013 474041 474072 477369 484185 488955 495542 503512 504464 506074 509446 510772 543655 544004 544969 548513 557939 564124 566906 584202 595658 598374 600042 604379 613245 617094 628672 648452 658481 667151 673256 674292 705011 705030 705440 706547 719063 719829 722189 722313 722961 723241 727494 729255 732133 734450 736428 738311 738342 738346 739634 740074 747796 754935 755017 755238 755935 757382 762716 763293 763571 763575 763593 764201 764243 764519 766502 771159 779582 779958 780854 781408 783432 787585 787591 790552 792249 793455 799903 800559 802080 807281 811775 814976 814984 816154 816164 818843 821792 824712 825541 825620 826238 826374 ] |
||||||||||||||||||||||||||||||
|
16.83 ms (11.48%) |
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 755238 802080 402892 595658 544969 584202 793455 604379 424624 474072 816154 824712 825541 719829 781408 807281 732133 472013 600042 764201 722313 814976 504464 787585 790552 736428 738311 747796 762716 763571 763575 764243 722189 469906 811775 800559 763293 391496 826238 509446 432897 446200 428779 484185 814984 441923 674292 495542 780854 441811 391947 414646 488955 667151 771159 755935 764519 474041 543655 557939 462830 402887 455597 598374 427129 417939 438982 439055 410251 462957 477369 455366 456486 510772 503512 436418 424518 412158 825620 826374 816164 821792 818843 469271 506074 548513 544004 564124 566906 648452 705011 723241 658481 705030 706547 719063 722961 673256 705440 613245 617094 628672 779582 787591 792249 779958 799903 734450 738342 783432 739634 766502 727494 738346 754935 729255 755017 757382 740074 763593 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (2.03%) |
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 391496 391947 402887 402892 410251 412158 414646 417939 424518 424624 427129 428779 432897 436418 438982 439055 441811 441923 446200 455366 455597 456486 462830 462957 469271 469906 472013 474041 474072 477369 484185 488955 495542 503512 504464 506074 509446 510772 543655 544004 544969 548513 557939 564124 566906 584202 595658 598374 600042 604379 613245 617094 628672 648452 658481 667151 673256 674292 705011 705030 705440 706547 719063 719829 722189 722313 722961 723241 727494 729255 732133 734450 736428 738311 738342 738346 739634 740074 747796 754935 755017 755238 755935 757382 762716 763293 763571 763575 763593 764201 764243 764519 766502 771159 779582 779958 780854 781408 783432 787585 787591 790552 792249 793455 799903 800559 802080 807281 811775 814976 814984 816154 816164 818843 821792 824712 825541 825620 826238 826374 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian blowjob webcam"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (1.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск минет оральн секс вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.22%) |
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.