Query Metrics
7
Database Queries
7
Different statements
151.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.15 ms (83.42%) |
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 6741 126458 385228 391677 395735 396245 399062 399874 400714 401976 402048 402238 409995 411237 412827 443093 452828 453488 455841 458609 459849 461733 475021 476962 482080 482087 509600 524213 530018 530494 531090 531588 534028 536252 537767 543013 549063 563618 565255 566158 569677 574292 576523 579358 590360 591393 593964 594213 595853 605326 605341 605353 618782 628090 628407 628409 628419 637134 640772 641677 665378 665392 668646 671619 671644 671890 673203 678769 680154 680185 703142 707329 710391 717814 719235 721439 722596 727748 733170 740059 740500 741533 742818 749688 752599 755696 758986 759587 760214 760218 761170 761580 765710 766851 767020 767217 769746 769786 770981 771013 773907 778980 779704 786458 789182 790374 790394 790972 800321 801272 804995 805207 810533 810838 814487 819311 819537 827642 827982 ] |
||||||||||||||||||||||||||||||
|
15.15 ms (10.02%) |
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 819537 827982 459849 531588 576523 800321 801272 786458 767020 767217 779704 534028 399062 814487 566158 665378 665392 673203 717814 668646 671644 703142 719235 721439 722596 641677 590360 605326 605353 790374 778980 733170 742818 752599 758986 760214 765710 766851 805207 741533 759587 761580 766889 727748 760218 761170 771013 707329 789182 402048 402238 412827 6741 569677 399874 475021 443093 455841 482087 536252 461733 543013 678769 594213 628407 476962 409995 819311 827642 537767 563618 710391 605341 618782 790972 810838 740059 773907 740500 755696 770981 126458 385228 396245 400714 401976 458609 509600 549063 574292 671890 593964 591393 804995 810533 790394 749688 769786 769746 395735 391677 453488 680185 452828 628419 640772 482080 524213 411237 530018 530494 531090 579358 565255 680154 671619 637134 595853 628090 628409 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (2.17%) |
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 6741 126458 385228 391677 395735 396245 399062 399874 400714 401976 402048 402238 409995 411237 412827 443093 452828 453488 455841 458609 459849 461733 475021 476962 482080 482087 509600 524213 530018 530494 531090 531588 534028 536252 537767 543013 549063 563618 565255 566158 569677 574292 576523 579358 590360 591393 593964 594213 595853 605326 605341 605353 618782 628090 628407 628409 628419 637134 640772 641677 665378 665392 668646 671619 671644 671890 673203 678769 680154 680185 703142 707329 710391 717814 719235 721439 722596 727748 733170 740059 740500 741533 742818 749688 752599 755696 758986 759587 760214 760218 761170 761580 765710 766851 767020 767217 769746 769786 770981 771013 773907 778980 779704 786458 789182 790374 790394 790972 800321 801272 804995 805207 810533 810838 814487 819311 819537 827642 827982 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen old anal"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen old анал"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen old анал"
]
|
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.