Query Metrics
7
Database Queries
7
Different statements
233.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.66 ms (88.65%) |
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 382465 468766 468826 474145 497428 497441 531525 531528 532158 532161 532166 532170 532266 532364 533433 533443 534249 534273 534284 534289 534298 534303 534307 534309 534313 534375 535836 536318 536347 537115 537117 570726 571266 577394 580424 585135 585689 586640 586675 587907 589116 593390 595758 596193 601833 606455 606863 615772 633136 640691 640706 643043 643072 643420 647595 650425 650456 713532 713547 713565 713569 744307 745062 756611 769337 771033 775466 775814 788149 788283 790784 792005 792621 792626 792655 795179 799143 804677 808461 808600 808621 810826 812911 813228 813408 814736 814738 814741 814774 814778 814781 814782 814790 814798 814800 814808 814811 814818 814825 814830 814857 814870 814871 814883 814888 814891 814908 814911 814914 814916 814924 814928 814929 814931 814933 814935 814938 814945 815273 815420 ] |
||||||||||||||||||||||||||||||
|
16.62 ms (7.13%) |
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 586675 606863 643043 790784 775466 804677 813408 795179 808461 536347 601833 814916 814818 814781 534313 497428 532364 537115 534289 468766 713565 650425 810826 814741 814782 814790 814924 814911 814929 474145 532266 534309 537117 531528 533433 534298 536318 532166 534307 534249 535836 580424 577394 713569 650456 595758 606455 593390 596193 643072 615772 792005 812911 745062 744307 814914 814931 814933 814736 814798 814825 814830 814811 814870 814883 814935 534273 533443 534375 571266 570726 647595 586640 585689 587907 775814 792655 808600 788283 792626 769337 799143 771033 633136 808621 814778 814800 640706 643420 382465 589116 815420 814888 814857 814871 814945 532170 713532 788149 813228 792621 640691 713547 815273 531525 534303 756611 814891 814938 585135 814774 814808 814908 814738 814928 468826 497441 532158 532161 534284 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.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 382465 468766 468826 474145 497428 497441 531525 531528 532158 532161 532166 532170 532266 532364 533433 533443 534249 534273 534284 534289 534298 534303 534307 534309 534313 534375 535836 536318 536347 537115 537117 570726 571266 577394 580424 585135 585689 586640 586675 587907 589116 593390 595758 596193 601833 606455 606863 615772 633136 640691 640706 643043 643072 643420 647595 650425 650456 713532 713547 713565 713569 744307 745062 756611 769337 771033 775466 775814 788149 788283 790784 792005 792621 792626 792655 795179 799143 804677 808461 808600 808621 810826 812911 813228 813408 814736 814738 814741 814774 814778 814781 814782 814790 814798 814800 814808 814811 814818 814825 814830 814857 814870 814871 814883 814888 814891 814908 814911 814914 814916 814924 814928 814929 814931 814933 814935 814938 814945 815273 815420 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brazzers big"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.70%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"brazzers большие"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.69%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"brazzers большие"
]
|
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.