Query Metrics
7
Database Queries
7
Different statements
149.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.30 ms (82.94%) |
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 271293 285321 382278 383722 385476 385710 386062 388115 396042 408249 411688 411710 414135 421550 423609 423630 426301 428966 429479 434325 442198 444776 448350 453114 453992 456864 457498 458910 460156 460960 464022 464598 468927 469759 482231 483978 484117 484803 490107 491487 493156 496479 499829 500815 504937 507243 508206 512813 512956 514920 521374 524178 524813 529164 540176 551951 552913 555153 562109 562904 562959 565062 565931 568332 570382 585155 585198 585318 593878 596134 597058 598783 602448 604106 605661 607385 614789 617552 618404 620912 639140 660426 670663 670904 681182 681286 686069 688554 695913 696115 706467 708886 718829 719128 721230 730111 733178 734789 737113 738749 742480 748142 750110 750195 750626 755108 755388 768878 773226 782398 782404 790813 796027 796543 801206 811560 811950 814178 817878 823940 ] |
||||||||||||||||||||||||||||||
|
15.34 ms (10.23%) |
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 617552 585198 614789 782398 796027 750626 801206 773226 734789 738749 750110 755388 750195 444776 448350 453992 504937 524813 507243 570382 396042 434325 464598 493156 490107 811560 565931 607385 285321 817878 823940 469759 484803 529164 496479 514920 555153 670663 706467 719128 670904 602448 639140 585318 596134 585155 597058 620912 730111 733178 742480 737113 768878 782404 796543 428966 483978 468927 605661 411688 414135 429479 491487 458910 562109 562904 593878 442198 426301 457498 484117 524178 386062 383722 382278 456864 540176 512956 521374 551951 568332 562959 565062 681286 686069 688554 708886 695913 718829 660426 681182 696115 721230 552913 598783 618404 604106 790813 811950 748142 755108 385710 385476 271293 388115 408249 423609 423630 411710 421550 814178 453114 460156 460960 464022 482231 512813 508206 500815 499829 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.95%) |
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 271293 285321 382278 383722 385476 385710 386062 388115 396042 408249 411688 411710 414135 421550 423609 423630 426301 428966 429479 434325 442198 444776 448350 453114 453992 456864 457498 458910 460156 460960 464022 464598 468927 469759 482231 483978 484117 484803 490107 491487 493156 496479 499829 500815 504937 507243 508206 512813 512956 514920 521374 524178 524813 529164 540176 551951 552913 555153 562109 562904 562959 565062 565931 568332 570382 585155 585198 585318 593878 596134 597058 598783 602448 604106 605661 607385 614789 617552 618404 620912 639140 660426 670663 670904 681182 681286 686069 688554 695913 696115 706467 708886 718829 719128 721230 730111 733178 734789 737113 738749 742480 748142 750110 750195 750626 755108 755388 768878 773226 782398 782404 790813 796027 796543 801206 811560 811950 814178 817878 823940 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая hard"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая hard"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy hard"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.02%) |
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.