Query Metrics
7
Database Queries
7
Different statements
152.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.66 ms (81.21%) |
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 233683 317791 382562 383328 385422 386367 392790 395136 396973 398432 418936 425535 426080 427502 428146 428844 429542 434256 446297 451742 453776 453898 454863 459371 459658 461376 467150 467742 474850 477327 479550 480613 481333 486845 490468 490871 497214 507519 509082 510405 516101 517280 519260 519408 521350 523303 525145 525475 530347 532927 534040 534305 546610 561698 562779 565140 565177 565709 567389 570147 579839 581523 581793 586672 599243 601352 605962 610938 613239 615580 621700 623147 653491 668437 668459 671325 672902 678554 682223 682259 682351 684308 687119 691669 692604 698251 702878 713649 714596 715393 719485 720644 722232 722701 724763 724896 725580 730666 750043 759575 770368 770862 772096 775731 777734 783612 784994 786167 802491 807728 810132 813938 815437 816524 817305 819963 824346 825328 825674 827250 ] |
||||||||||||||||||||||||||||||
|
19.32 ms (12.69%) |
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 486845 317791 426080 428146 510405 521350 461376 668437 605962 610938 810132 481333 824346 467150 519260 534305 532927 570147 722701 671325 678554 786167 477327 395136 451742 534040 474850 687119 561698 599243 777734 427502 497214 519408 386367 392790 398432 418936 429542 825328 453776 565177 623147 784994 454863 490871 428844 382562 813938 516101 523303 581523 720644 615580 802491 730666 724763 770862 750043 770368 775731 425535 467742 581793 525145 385422 815437 446297 490468 530347 565709 682259 684308 668459 692604 565140 601352 586672 613239 807728 724896 453898 459371 479550 233683 507519 525475 817305 819963 816524 691669 698251 682223 562779 567389 783612 725580 759575 772096 383328 396973 434256 825674 827250 459658 480613 517280 509082 546610 722232 682351 714596 715393 653491 672902 702878 713649 719485 579839 621700 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.86%) |
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 233683 317791 382562 383328 385422 386367 392790 395136 396973 398432 418936 425535 426080 427502 428146 428844 429542 434256 446297 451742 453776 453898 454863 459371 459658 461376 467150 467742 474850 477327 479550 480613 481333 486845 490468 490871 497214 507519 509082 510405 516101 517280 519260 519408 521350 523303 525145 525475 530347 532927 534040 534305 546610 561698 562779 565140 565177 565709 567389 570147 579839 581523 581793 586672 599243 601352 605962 610938 613239 615580 621700 623147 653491 668437 668459 671325 672902 678554 682223 682259 682351 684308 687119 691669 692604 698251 702878 713649 714596 715393 719485 720644 722232 722701 724763 724896 725580 730666 750043 759575 770368 770862 772096 775731 777734 783612 784994 786167 802491 807728 810132 813938 815437 816524 817305 819963 824346 825328 825674 827250 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sleep blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спящ минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.91%) |
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.