Query Metrics
7
Database Queries
7
Different statements
219.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
191.01 ms (86.87%) |
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 24855 40360 79720 81022 146112 150487 187786 188373 188437 188610 232973 233135 233512 233710 233996 311235 311237 334847 340635 365875 365881 365908 366050 382058 382421 384124 386044 388762 391251 391659 391858 391861 391875 391930 391965 391989 392054 392213 392604 392671 392672 392675 394212 397629 397896 398553 398959 402896 403315 403317 411334 411381 411415 418080 433353 443326 451498 454279 454508 460760 463260 466012 466173 466231 466248 466840 466884 470722 472804 477987 478377 480656 481124 481915 482947 484397 484586 484615 484681 484685 484744 486355 487993 490406 490419 490856 490872 491950 506247 521147 523834 524876 525695 533734 537263 537972 546950 547809 555046 572669 573912 581126 581931 587846 599438 610033 620241 623493 705359 722221 722301 724052 724086 735945 740882 742729 759929 764148 766381 790781 ] |
||||||||||||||||||||||||||||||
|
17.67 ms (8.04%) |
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 397896 233710 311235 366050 724052 392213 392054 443326 365908 391251 392671 418080 451498 466173 403317 490856 411334 384124 397629 742729 365881 382421 150487 766381 187786 466840 188373 722221 403315 392675 466012 79720 392672 470722 481915 188610 537263 487993 482947 398959 484615 759929 620241 581126 146112 433353 24855 764148 490419 484586 555046 460760 454508 478377 490406 233512 311237 722301 40360 81022 521147 599438 705359 724086 386044 477987 391875 391858 472804 484397 382058 486355 790781 454279 533734 623493 334847 233135 391659 537972 735945 398553 481124 466231 463260 391965 546950 365875 388762 392604 394212 466248 411381 484685 484744 523834 525695 480656 547809 572669 610033 340635 524876 232973 490872 411415 581931 233996 402896 491950 391861 391930 587846 740882 391989 466884 573912 188437 506247 484681 ] |
||||||||||||||||||||||||||||||
|
3.89 ms (1.77%) |
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 24855 40360 79720 81022 146112 150487 187786 188373 188437 188610 232973 233135 233512 233710 233996 311235 311237 334847 340635 365875 365881 365908 366050 382058 382421 384124 386044 388762 391251 391659 391858 391861 391875 391930 391965 391989 392054 392213 392604 392671 392672 392675 394212 397629 397896 398553 398959 402896 403315 403317 411334 411381 411415 418080 433353 443326 451498 454279 454508 460760 463260 466012 466173 466231 466248 466840 466884 470722 472804 477987 478377 480656 481124 481915 482947 484397 484586 484615 484681 484685 484744 486355 487993 490406 490419 490856 490872 491950 506247 521147 523834 524876 525695 533734 537263 537972 546950 547809 555046 572669 573912 581126 581931 587846 599438 610033 620241 623493 705359 722221 722301 724052 724086 735945 740882 742729 759929 764148 766381 790781 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русское тещу"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.69%) |
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.