Query Metrics
7
Database Queries
7
Different statements
152.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.78 ms (81.96%) |
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 13954 108018 168977 177739 348918 383523 387380 390292 394931 395848 396110 396575 398204 402931 403833 410956 413748 416967 417246 420340 421807 424795 426432 428492 430815 432338 434587 434992 436869 447308 448903 449516 451799 452654 453418 454863 455633 457908 458466 458742 459350 459449 459578 460641 462836 462883 463031 464461 465616 466526 466708 467806 471311 472080 473804 475444 478145 478336 478788 479296 482014 483906 484053 484054 485479 486620 486668 487028 492751 493937 497545 497551 498724 498753 507152 507194 510985 511209 511984 522665 525900 526697 551366 551844 551973 552070 552402 552483 552633 552696 553452 554128 554187 558375 558520 561330 565177 566751 567193 569854 569878 570207 570528 570656 571539 571893 571917 572116 572621 573667 578375 580735 583320 583426 587338 590334 594215 654836 672706 806883 ] |
||||||||||||||||||||||||||||||
|
16.33 ms (10.73%) |
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 177739 13954 396575 398204 434587 413748 410956 484054 525900 552070 558375 569878 571917 573667 553452 565177 569854 570207 570528 570656 583320 552696 554187 571539 571893 578375 672706 654836 552633 572116 572621 580735 594215 590334 448903 416967 421807 428492 432338 479296 108018 454863 434992 467806 507152 497545 383523 168977 394931 387380 390292 396110 403833 424795 426432 436869 417246 420340 451799 452654 458466 459449 463031 466708 478145 486668 487028 449516 453418 455633 457908 466526 472080 482014 483906 484053 486620 459350 460641 471311 485479 492751 498753 511209 511984 522665 526697 510985 498724 507194 497551 462883 464461 465616 473804 478336 478788 493937 551366 551973 552402 561330 554128 583426 558520 567193 551844 552483 566751 587338 806883 348918 395848 402931 430815 447308 458742 459578 462836 475444 ] |
||||||||||||||||||||||||||||||
|
3.58 ms (2.35%) |
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 13954 108018 168977 177739 348918 383523 387380 390292 394931 395848 396110 396575 398204 402931 403833 410956 413748 416967 417246 420340 421807 424795 426432 428492 430815 432338 434587 434992 436869 447308 448903 449516 451799 452654 453418 454863 455633 457908 458466 458742 459350 459449 459578 460641 462836 462883 463031 464461 465616 466526 466708 467806 471311 472080 473804 475444 478145 478336 478788 479296 482014 483906 484053 484054 485479 486620 486668 487028 492751 493937 497545 497551 498724 498753 507152 507194 510985 511209 511984 522665 525900 526697 551366 551844 551973 552070 552402 552483 552633 552696 553452 554128 554187 558375 558520 561330 565177 566751 567193 569854 569878 570207 570528 570656 571539 571893 571917 572116 572621 573667 578375 580735 583320 583426 587338 590334 594215 654836 672706 806883 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"с членом девка"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"член девк"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"член девк"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.10%) |
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.