Query Metrics
7
Database Queries
7
Different statements
221.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
201.24 ms (90.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 391893 393384 397895 403938 410855 417844 419176 429025 453512 453852 461884 462685 466317 469494 481591 502021 517301 530289 532367 532681 532717 533689 534133 535789 536202 539018 540122 543688 543982 544252 545091 553241 554876 556050 557942 566394 579305 592708 593859 593893 597183 600058 603515 603608 603646 603649 606535 610780 617692 622116 622179 625363 632048 632251 633045 633049 633965 635780 635863 641852 648996 649169 649627 650642 651313 651318 651423 653603 653628 653634 653880 654293 669637 679549 692470 693816 694128 696167 702954 703207 711258 718059 723074 724449 731358 732704 737893 744856 748446 749548 755134 758035 761453 762269 767857 767861 770837 775794 779170 779794 783112 789011 790413 793200 793231 801467 804508 805368 806376 809184 809399 812998 817434 817663 825628 825949 825998 827830 827873 827896 ] |
||||||||||||||||||||||||||||||
|
10.47 ms (4.72%) |
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 453852 553241 597183 556050 466317 453512 481591 653634 651313 653628 711258 653603 593893 622116 635780 633965 825949 809399 737893 429025 461884 603608 633045 502021 761453 693816 610780 793200 557942 603649 417844 817434 649169 724449 393384 462685 517301 593859 748446 827873 827896 530289 532717 540122 534133 566394 554876 648996 651423 679549 692470 694128 649627 651318 653880 654293 696167 592708 600058 622179 632251 603646 633049 635863 617692 603515 755134 793231 779170 806376 732704 758035 801467 702954 805368 703207 783112 632048 410855 625363 535789 543688 650642 825998 579305 545091 779794 536202 419176 718059 790413 804508 809184 744856 812998 397895 391893 817663 825628 532681 544252 770837 749548 762269 767857 767861 731358 789011 403938 827830 532367 669637 469494 543982 723074 641852 775794 533689 539018 606535 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"threesome amateur"
]
|
||||||||||||||||||||||||||||||
|
2.32 ms (1.05%) |
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 391893 393384 397895 403938 410855 417844 419176 429025 453512 453852 461884 462685 466317 469494 481591 502021 517301 530289 532367 532681 532717 533689 534133 535789 536202 539018 540122 543688 543982 544252 545091 553241 554876 556050 557942 566394 579305 592708 593859 593893 597183 600058 603515 603608 603646 603649 606535 610780 617692 622116 622179 625363 632048 632251 633045 633049 633965 635780 635863 641852 648996 649169 649627 650642 651313 651318 651423 653603 653628 653634 653880 654293 669637 679549 692470 693816 694128 696167 702954 703207 711258 718059 723074 724449 731358 732704 737893 744856 748446 749548 755134 758035 761453 762269 767857 767861 770837 775794 779170 779794 783112 789011 790413 793200 793231 801467 804508 805368 806376 809184 809399 812998 817434 817663 825628 825949 825998 827830 827873 827896 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс втро любительск"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.