Query Metrics
7
Database Queries
7
Different statements
156.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.21 ms (83.23%) |
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 105477 151564 153869 192951 213057 285846 382450 384752 384810 387186 392489 395632 396969 400460 407761 410855 411628 411947 414688 416311 418488 420154 420275 424429 429531 430342 431213 442131 443393 443756 446821 447496 451455 451611 453145 454279 455363 458650 463221 465340 465634 466807 467285 467342 469493 471472 474382 475039 475899 478922 487060 491767 505718 506235 519238 522814 523624 529292 538379 544504 545710 545711 548651 549253 552309 552695 558828 560392 560485 560562 562975 562993 563214 567315 570418 570505 570626 571572 572142 572798 573688 573777 573789 574490 574825 574851 574920 575080 575100 575138 575147 575156 575503 575769 575770 576072 576098 576293 576405 576410 578386 584436 588838 591288 595432 596763 606824 629847 699161 726962 742248 748239 758299 760925 788881 789711 801173 801405 802487 802806 ] |
||||||||||||||||||||||||||||||
|
16.52 ms (10.56%) |
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 802487 726962 742248 760925 699161 801405 802806 151564 387186 392489 414688 454279 285846 396969 451455 105477 458650 431213 455363 475899 478922 505718 519238 538379 506235 522814 523624 384752 213057 153869 192951 411628 420275 429531 407761 420154 442131 443393 430342 410855 446821 451611 453145 463221 487060 467342 475039 491767 465634 471472 529292 466807 469493 474382 552309 575138 575147 575503 576098 544504 545710 560485 571572 572798 573688 574825 575100 575156 575769 576072 576293 576410 545711 552695 560392 560562 562993 567315 570418 570626 573777 575080 575770 578386 548651 549253 558828 562975 563214 570505 572142 573789 574490 574851 574920 576405 584436 591288 595432 596763 588838 788881 758299 801173 748239 606824 629847 789711 382450 384810 395632 400460 411947 416311 424429 443756 447496 467285 418488 465340 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.92%) |
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 105477 151564 153869 192951 213057 285846 382450 384752 384810 387186 392489 395632 396969 400460 407761 410855 411628 411947 414688 416311 418488 420154 420275 424429 429531 430342 431213 442131 443393 443756 446821 447496 451455 451611 453145 454279 455363 458650 463221 465340 465634 466807 467285 467342 469493 471472 474382 475039 475899 478922 487060 491767 505718 506235 519238 522814 523624 529292 538379 544504 545710 545711 548651 549253 552309 552695 558828 560392 560485 560562 562975 562993 563214 567315 570418 570505 570626 571572 572142 572798 573688 573777 573789 574490 574825 574851 574920 575080 575100 575138 575147 575156 575503 575769 575770 576072 576098 576293 576405 576410 578386 584436 588838 591288 595432 596763 606824 629847 699161 726962 742248 748239 758299 760925 788881 789711 801173 801405 802487 802806 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"kissing boy"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"kissing парен"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"kissing парен"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.95%) |
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.