Query Metrics
7
Database Queries
7
Different statements
193.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.07 ms (88.87%) |
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 143572 187595 188266 359102 382184 385334 387496 397217 397223 397647 398244 407686 407707 407887 409390 409940 411333 411338 411929 427981 451488 457991 460015 462607 465390 466155 467550 471012 471116 476363 478020 479136 484395 493587 496854 549639 556451 558004 563226 570169 589662 590345 605083 644529 647856 664975 666028 667655 677971 698496 707476 708827 714153 716221 717651 718987 720264 720585 721983 724284 725350 729814 729819 730076 731482 731796 732373 733029 733098 733119 735987 739160 740169 740791 741904 741906 745028 745382 746025 746106 746107 747106 757241 757933 766663 770110 774332 775571 776339 779197 780614 781648 781670 781995 785436 788237 788877 789526 789534 794629 794701 797266 804217 804251 807189 807605 808057 811060 817870 818638 818924 818949 818991 819009 820115 824806 824906 825114 826661 ] |
||||||||||||||||||||||||||||||
|
11.43 ms (5.90%) |
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 484395 779197 741904 714153 707476 745028 387496 397223 818924 819009 788877 794701 780614 757241 807189 774332 746106 804217 647856 556451 409390 407707 409940 741906 745382 720585 187595 466155 467550 476363 359102 471012 457991 451488 465390 644529 570169 590345 397647 817870 820115 824806 826661 666028 667655 775571 724284 725350 785436 788237 804251 766663 733029 733098 746025 698496 811060 770110 807605 397217 462607 716221 721983 720264 589662 732373 411333 411338 479136 824906 735987 818949 818991 677971 717651 781670 794629 731482 733119 797266 729814 739160 757933 740169 824187 718987 708827 664975 605083 731796 747106 746107 740791 143572 407887 478020 493587 549639 496854 818638 730076 781648 411929 460015 427981 385334 188266 382184 398244 407686 825114 471116 558004 563226 776339 781995 789534 808057 789526 729819 ] |
||||||||||||||||||||||||||||||
|
3.30 ms (1.71%) |
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 143572 187595 188266 359102 382184 385334 387496 397217 397223 397647 398244 407686 407707 407887 409390 409940 411333 411338 411929 427981 451488 457991 460015 462607 465390 466155 467550 471012 471116 476363 478020 479136 484395 493587 496854 549639 556451 558004 563226 570169 589662 590345 605083 644529 647856 664975 666028 667655 677971 698496 707476 708827 714153 716221 717651 718987 720264 720585 721983 724284 725350 729814 729819 730076 731482 731796 732373 733029 733098 733119 735987 739160 740169 740791 741904 741906 745028 745382 746025 746106 746107 747106 757241 757933 766663 770110 774332 775571 776339 779197 780614 781648 781670 781995 785436 788237 788877 789526 789534 794629 794701 797266 804217 804251 807189 807605 808057 811060 817870 818638 818924 818949 818991 819009 820115 824806 824906 825114 826661 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature big pussy"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature большие pussy"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature большие pussy"
]
|
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.