Query Metrics
7
Database Queries
7
Different statements
151.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.25 ms (81.77%) |
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 11870 382024 385095 387656 392745 396905 397122 397846 398512 398724 398801 400072 401510 402026 403596 404072 405531 410636 414509 415800 418213 419661 421288 421394 428987 429015 429068 434067 434301 434710 443215 443492 443647 445497 445780 446160 446874 447131 449942 451246 452392 464732 466161 466772 467372 469810 473844 476360 476420 478472 478746 479021 480277 480988 483947 484522 487439 489061 489235 490502 495706 496368 497715 508198 513802 514692 514992 516970 517190 518472 526032 527195 527558 527774 528271 529854 530018 530663 530709 531208 536668 536681 537206 539938 540608 540829 540908 551329 551455 556080 576346 598828 629858 690468 693830 699670 702170 702438 737685 742462 745006 746470 763960 788706 799126 816372 816549 817524 818681 818711 819533 819554 820878 821496 821578 821655 822167 823360 828460 828845 ] |
||||||||||||||||||||||||||||||
|
17.08 ms (11.24%) |
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 551329 551455 556080 693830 699670 702170 690468 629858 788706 799126 763960 737685 746470 742462 745006 702438 392745 397846 398724 402026 398512 415800 434710 434067 443215 429068 421288 443492 496368 479021 414509 434301 480988 451246 497715 421394 489061 529854 530663 531208 536668 536681 530018 539938 540608 530709 537206 576346 598828 446160 476360 428987 466161 446874 464732 466772 405531 418213 476420 508198 514692 516970 528271 487439 495706 517190 518472 527195 540908 385095 382024 11870 387656 397122 396905 398801 400072 401510 404072 403596 429015 410636 443647 419661 819533 820878 540829 817524 818711 821578 821655 816372 816549 818681 819554 823360 821496 822167 828845 828460 452392 469810 478472 478746 484522 445497 447131 467372 473844 483947 490502 445780 449942 480277 489235 513802 514992 526032 527558 527774 ] |
||||||||||||||||||||||||||||||
|
3.31 ms (2.18%) |
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 11870 382024 385095 387656 392745 396905 397122 397846 398512 398724 398801 400072 401510 402026 403596 404072 405531 410636 414509 415800 418213 419661 421288 421394 428987 429015 429068 434067 434301 434710 443215 443492 443647 445497 445780 446160 446874 447131 449942 451246 452392 464732 466161 466772 467372 469810 473844 476360 476420 478472 478746 479021 480277 480988 483947 484522 487439 489061 489235 490502 495706 496368 497715 508198 513802 514692 514992 516970 517190 518472 526032 527195 527558 527774 528271 529854 530018 530663 530709 531208 536668 536681 537206 539938 540608 540829 540908 551329 551455 556080 576346 598828 629858 690468 693830 699670 702170 702438 737685 742462 745006 746470 763960 788706 799126 816372 816549 817524 818681 818711 819533 819554 820878 821496 821578 821655 822167 823360 828460 828845 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny white an"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые white"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые white"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.06%) |
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.