Query Metrics
7
Database Queries
7
Different statements
178.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.30 ms (86.51%) |
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 5565 7950 8207 34645 73990 137351 146547 229704 382339 382488 382581 387213 388223 389912 390406 391033 398475 399187 399356 400569 402901 403400 404247 404261 406957 418371 421065 428454 428822 433917 434379 467549 474657 519243 525156 530475 532559 533434 537664 540161 550373 551814 559708 575596 580986 596115 597018 599115 605340 612854 621315 624653 632358 646395 646942 662397 668512 671407 678940 681129 681636 682138 696553 702463 709319 711010 713574 717545 717789 722035 724241 738508 741281 744642 751585 751603 760915 763079 765840 769346 770665 770900 770911 771832 772227 775860 776279 777813 777893 778739 779116 779570 780407 784725 784998 785349 787274 787406 788783 789469 789794 790014 791952 795173 799290 802835 804065 804465 805677 805760 808332 808342 812833 813945 815137 815388 815508 816242 820938 822623 ] |
||||||||||||||||||||||||||||||
|
14.17 ms (7.95%) |
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 382339 391033 813945 815508 815388 713574 621315 799290 802835 770900 772227 771832 624653 632358 702463 73990 399187 406957 389912 229704 382488 146547 418371 717789 390406 400569 421065 816242 540161 525156 580986 711010 722035 551814 596115 599115 777893 784998 791952 751603 770665 763079 765840 724241 744642 789794 382581 467549 434379 788783 559708 399356 7950 402901 681129 682138 795173 805760 808342 790014 5565 741281 769346 776279 779570 8207 404247 550373 696553 597018 775860 770911 804465 388223 787406 137351 34645 575596 784725 403400 433917 815137 820938 530475 474657 662397 646942 717545 779116 780407 808332 787274 805677 760915 387213 398475 428454 404261 778739 428822 822623 519243 537664 532559 533434 671407 681636 646395 668512 678940 709319 612854 605340 777813 789469 812833 785349 804065 738508 751585 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.54%) |
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 5565 7950 8207 34645 73990 137351 146547 229704 382339 382488 382581 387213 388223 389912 390406 391033 398475 399187 399356 400569 402901 403400 404247 404261 406957 418371 421065 428454 428822 433917 434379 467549 474657 519243 525156 530475 532559 533434 537664 540161 550373 551814 559708 575596 580986 596115 597018 599115 605340 612854 621315 624653 632358 646395 646942 662397 668512 671407 678940 681129 681636 682138 696553 702463 709319 711010 713574 717545 717789 722035 724241 738508 741281 744642 751585 751603 760915 763079 765840 769346 770665 770900 770911 771832 772227 775860 776279 777813 777893 778739 779116 779570 780407 784725 784998 785349 787274 787406 788783 789469 789794 790014 791952 795173 799290 802835 804065 804465 805677 805760 808332 808342 812833 813945 815137 815388 815508 816242 820938 822623 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beauty blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"beauty минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"beauty минет оральн секс"
]
|
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.