Query Metrics
7
Database Queries
7
Different statements
220.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
190.68 ms (86.48%) |
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 97045 386134 391911 391941 391986 393742 400719 405112 427097 427170 434289 442643 443487 443700 444238 453408 455180 455767 457048 460903 461467 461948 462527 462553 463016 463096 465553 470325 470826 474114 474119 475102 476468 476598 476916 477389 477994 478284 478847 479343 480638 482066 484057 484163 485374 485581 486116 486376 487168 488149 490005 490279 491072 491079 492391 493033 496289 499022 502817 502913 504270 509028 510077 510425 513349 517248 518313 518563 519676 525529 525582 528140 528642 528913 529074 541623 541636 542960 546954 548228 548229 549335 549406 549768 551477 551936 551944 552461 552617 552777 554226 554646 556029 558208 559120 559123 559124 561061 565306 565308 566146 573905 574204 574235 576645 576687 576722 577375 580715 581157 584709 584714 587763 610607 622381 641375 650800 694063 747140 784146 ] |
||||||||||||||||||||||||||||||
|
20.21 ms (9.16%) |
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 487168 492391 491072 528140 525529 478284 528913 573905 694063 580715 587763 641375 461467 480638 465553 470325 525582 513349 488149 502913 504270 528642 549335 551944 552777 461948 455180 486376 551936 549768 610607 493033 486116 97045 442643 474114 457048 509028 576687 577375 650800 581157 784146 391941 443700 476468 470826 476916 479343 482066 484163 484057 490279 491079 393742 576722 475102 476598 517248 552617 391911 554226 565306 565308 427170 391986 434289 477994 519676 510425 485374 499022 566146 554646 462527 552461 559124 747140 622381 453408 463096 548228 574204 551477 443487 490005 386134 474119 549406 559123 405112 460903 462553 478847 510077 485581 496289 541623 541636 546954 584714 529074 584709 558208 400719 455767 576645 444238 502817 463016 518313 574235 548229 427097 477389 518563 559120 556029 561061 542960 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.36%) |
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 97045 386134 391911 391941 391986 393742 400719 405112 427097 427170 434289 442643 443487 443700 444238 453408 455180 455767 457048 460903 461467 461948 462527 462553 463016 463096 465553 470325 470826 474114 474119 475102 476468 476598 476916 477389 477994 478284 478847 479343 480638 482066 484057 484163 485374 485581 486116 486376 487168 488149 490005 490279 491072 491079 492391 493033 496289 499022 502817 502913 504270 509028 510077 510425 513349 517248 518313 518563 519676 525529 525582 528140 528642 528913 529074 541623 541636 542960 546954 548228 548229 549335 549406 549768 551477 551936 551944 552461 552617 552777 554226 554646 556029 558208 559120 559123 559124 561061 565306 565308 566146 573905 574204 574235 576645 576687 576722 577375 580715 581157 584709 584714 587763 610607 622381 641375 650800 694063 747140 784146 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"farm girl"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"farm девушк"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.66%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"farm девушк"
]
|
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.