Query Metrics
7
Database Queries
7
Different statements
187.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.69 ms (86.41%) |
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 336986 396676 415365 416943 422657 423039 423283 426737 429292 436440 440711 443749 444027 463124 470080 473529 484097 485308 486658 487087 489820 489931 491286 491365 491663 491666 491671 491672 492727 496448 497424 499794 501804 505238 508198 508437 508848 508850 508857 508865 508881 511713 512900 513662 514781 517223 519690 519695 521802 522072 522569 522837 524199 524717 525235 527630 528092 531583 539101 540614 540928 541879 544937 548257 548651 548671 550047 552632 554366 561085 566791 567223 570922 574805 574810 575093 575458 575473 575482 575493 575520 575754 576030 576063 576413 577023 580673 580675 597244 600472 602232 605523 606690 651944 653520 653554 653560 653561 670540 695124 709814 712514 713684 715421 726306 735727 740414 742151 752773 754805 763814 766422 766687 778344 778569 794508 806331 807689 819165 821871 ] |
||||||||||||||||||||||||||||||
|
17.38 ms (9.29%) |
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 485308 566791 492727 575754 440711 489931 528092 735727 531583 525235 497424 600472 740414 519690 544937 499794 436440 444027 819165 561085 670540 715421 763814 766422 754805 742151 489820 550047 580673 470080 508437 426737 580675 491666 423039 653554 473529 415365 575458 575473 486658 821871 540614 605523 778569 778344 501804 548671 651944 508865 517223 575493 522569 505238 508848 514781 524199 597244 496448 695124 512900 577023 709814 752773 570922 540928 574810 575520 606690 463124 511713 491663 491672 508850 508881 491671 602232 429292 521802 807689 653560 423283 522072 487087 522837 576413 576030 513662 766687 396676 712514 713684 794508 443749 416943 336986 422657 491286 519695 548257 567223 575482 574805 576063 552632 575093 653520 548651 554366 726306 539101 491365 508857 524717 527630 484097 653561 806331 508198 541879 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.30%) |
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 336986 396676 415365 416943 422657 423039 423283 426737 429292 436440 440711 443749 444027 463124 470080 473529 484097 485308 486658 487087 489820 489931 491286 491365 491663 491666 491671 491672 492727 496448 497424 499794 501804 505238 508198 508437 508848 508850 508857 508865 508881 511713 512900 513662 514781 517223 519690 519695 521802 522072 522569 522837 524199 524717 525235 527630 528092 531583 539101 540614 540928 541879 544937 548257 548651 548671 550047 552632 554366 561085 566791 567223 570922 574805 574810 575093 575458 575473 575482 575493 575520 575754 576030 576063 576413 577023 580673 580675 597244 600472 602232 605523 606690 651944 653520 653554 653560 653561 670540 695124 709814 712514 713684 715421 726306 735727 740414 742151 752773 754805 763814 766422 766687 778344 778569 794508 806331 807689 819165 821871 ] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"бдсм 18-19 летние"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.74%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бдсм 18 19 лет"
]
|
||||||||||||||||||||||||||||||
|
1.12 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бдсм 18 19 лет"
]
|
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.