Query Metrics
7
Database Queries
7
Different statements
160.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.46 ms (84.89%) |
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 384355 404345 405472 429314 429754 445599 461527 465110 473111 478490 502575 537236 541073 548046 548656 548678 550453 550611 552131 552142 552388 552448 552656 558824 558840 559020 560662 562128 562293 562306 562310 562373 564668 565054 565324 565358 567633 567769 569070 569471 570188 570279 570494 570532 570668 571005 571654 571898 571909 572062 572108 572391 572521 573045 573634 573674 573678 573681 573682 573712 573812 573967 575060 575064 575085 575202 575453 575485 575523 576024 580691 580715 581713 585398 587255 589154 592015 596504 597940 598538 598671 599752 602939 604026 604451 604702 607155 619221 619505 635160 636026 640537 702634 724193 727374 729711 732000 733863 735562 738219 739871 741445 742181 742192 742195 743018 743111 744261 753364 760923 769223 784611 806097 810591 810994 814554 821631 821855 827324 ] |
||||||||||||||||||||||||||||||
|
14.01 ms (8.72%) |
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 735562 742195 743018 738219 741445 742181 742192 743111 724193 727374 732000 744261 753364 739871 619505 640537 806097 810591 810994 827324 729711 814554 567633 552656 564668 580691 541073 702634 576024 580715 604451 636026 585398 596504 598671 604026 604702 619221 595204 733863 405472 581713 589154 597940 592015 598538 587255 607155 635160 537236 562373 548046 502575 571005 602939 550611 558840 569070 562128 565324 599752 429754 465110 760923 429314 445599 478490 404345 473111 461527 821631 769223 784611 384355 821855 548656 550453 552131 552142 552388 552448 559020 562306 562310 565358 567769 569471 570188 570494 570532 570668 571909 572521 573045 573812 575064 575485 575523 548678 558824 560662 562293 565054 570279 571654 571898 572062 572108 572391 573634 573674 573678 573681 573682 573712 573967 575060 575085 575202 575453 ] |
||||||||||||||||||||||||||||||
|
3.25 ms (2.02%) |
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 384355 404345 405472 429314 429754 445599 461527 465110 473111 478490 502575 537236 541073 548046 548656 548678 550453 550611 552131 552142 552388 552448 552656 558824 558840 559020 560662 562128 562293 562306 562310 562373 564668 565054 565324 565358 567633 567769 569070 569471 570188 570279 570494 570532 570668 571005 571654 571898 571909 572062 572108 572391 572521 573045 573634 573674 573678 573681 573682 573712 573812 573967 575060 575064 575085 575202 575453 575485 575523 576024 580691 580715 581713 585398 587255 589154 592015 596504 597940 598538 598671 599752 602939 604026 604451 604702 607155 619221 619505 635160 636026 640537 702634 724193 727374 729711 732000 733863 735562 738219 739871 741445 742181 742192 742195 743018 743111 744261 753364 760923 769223 784611 806097 810591 810994 814554 821631 821855 827324 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big small cock"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие маленькая cock"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие маленькая cock"
]
|
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.