Query Metrics
7
Database Queries
7
Different statements
187.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.45 ms (87.88%) |
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 91891 384853 386915 387080 392623 398784 399195 400210 400894 402034 408940 409759 428484 428966 436644 443127 451518 454907 459600 466704 467792 473023 492808 504208 510640 512650 515734 516143 547566 548295 550549 552161 552192 552696 556899 559907 566366 566574 569763 569847 570004 570218 570301 570454 571885 571887 571893 571922 573647 573708 577570 578033 579236 580361 581600 583612 590441 594267 594339 595777 596507 597553 598533 598592 600063 603105 611754 611924 614445 617968 622858 626239 637189 653552 655601 670373 672492 672891 674327 676769 676974 679354 680493 680650 686585 693032 693883 693962 695826 708718 714297 716534 723504 723820 728260 732060 740758 746555 750710 751332 753155 755897 764719 766219 769070 770436 775112 775384 778915 786513 793630 801232 803658 804053 804825 807541 809299 810725 818582 821443 ] |
||||||||||||||||||||||||||||||
|
12.93 ms (6.91%) |
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 552161 556899 566366 569847 570004 570454 577570 547566 548295 550549 552696 559907 570218 570301 571885 571893 571922 573708 578033 579236 580361 581600 583612 672891 676974 653552 655601 672492 674327 676769 680493 693032 693962 695826 714297 670373 679354 680650 686585 693883 708718 716534 552192 566574 569763 571887 573647 590441 594339 617968 637189 597553 611754 611924 614445 622858 594267 598533 600063 603105 595777 596507 626239 775384 807541 801232 809299 750710 751332 769070 793630 803658 804825 810725 732060 766219 723820 755897 746555 728260 740758 753155 764719 770436 723504 775112 778915 786513 804053 466704 387080 392623 400210 400894 408940 409759 428966 436644 386915 398784 454907 459600 467792 473023 402034 451518 510640 515734 516143 492808 512650 598592 504208 384853 91891 399195 428484 443127 818582 821443 ] |
||||||||||||||||||||||||||||||
|
3.24 ms (1.73%) |
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 91891 384853 386915 387080 392623 398784 399195 400210 400894 402034 408940 409759 428484 428966 436644 443127 451518 454907 459600 466704 467792 473023 492808 504208 510640 512650 515734 516143 547566 548295 550549 552161 552192 552696 556899 559907 566366 566574 569763 569847 570004 570218 570301 570454 571885 571887 571893 571922 573647 573708 577570 578033 579236 580361 581600 583612 590441 594267 594339 595777 596507 597553 598533 598592 600063 603105 611754 611924 614445 617968 622858 626239 637189 653552 655601 670373 672492 672891 674327 676769 676974 679354 680493 680650 686585 693032 693883 693962 695826 708718 714297 716534 723504 723820 728260 732060 740758 746555 750710 751332 753155 755897 764719 766219 769070 770436 775112 775384 778915 786513 793630 801232 803658 804053 804825 807541 809299 810725 818582 821443 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny hot"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые hot"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые hot"
]
|
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.