Query Metrics
7
Database Queries
7
Different statements
189.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.24 ms (86.71%) |
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 468826 480390 530724 530725 530728 532262 532359 532364 534227 534240 534243 534245 534246 534253 534255 534259 534260 534262 534276 534286 534289 534294 534303 534310 534314 534317 534319 534851 535019 535020 535373 535825 535828 535829 535830 536332 536341 537107 537117 550954 564765 570730 577394 580424 581596 586668 587180 589116 595758 595992 596193 604430 609962 614032 615772 618647 643072 643106 647352 650343 650388 650421 650425 650456 676397 684173 693642 697766 713569 713574 744307 757362 759896 760839 765232 771005 771033 775800 775814 776566 782629 786813 792005 792633 792655 807542 808461 808622 811393 812911 814736 814738 814741 814752 814757 814777 814778 814781 814800 814806 814808 814818 814825 814831 814841 814852 814867 814871 814876 814887 814888 814889 814894 814908 814911 814912 814914 814928 814929 814932 ] |
||||||||||||||||||||||||||||||
|
14.53 ms (7.67%) |
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 534310 532262 534259 534227 535829 534240 534243 534314 535828 535830 570730 564765 650388 713574 604430 587180 614032 618647 609962 643106 811393 775800 765232 771005 814736 814741 814818 814781 814911 814929 537117 532364 534289 577394 713569 650456 650425 595758 596193 643072 615772 775814 792655 792005 812911 744307 771033 814777 814757 814778 814800 814867 814912 534317 536332 647352 684173 776566 808461 814806 814831 814894 814932 814752 814887 814841 814852 814876 480390 530725 534851 530724 534245 534260 534276 534319 535825 536341 537107 530728 534262 534286 534294 532359 534253 534255 535373 550954 650343 676397 595992 586668 782629 786813 759896 807542 760839 757362 697766 792633 808622 535019 814888 814914 814825 814871 814889 580424 468826 534246 589116 535020 814808 814908 814738 814928 534303 581596 693642 650421 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.39%) |
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 468826 480390 530724 530725 530728 532262 532359 532364 534227 534240 534243 534245 534246 534253 534255 534259 534260 534262 534276 534286 534289 534294 534303 534310 534314 534317 534319 534851 535019 535020 535373 535825 535828 535829 535830 536332 536341 537107 537117 550954 564765 570730 577394 580424 581596 586668 587180 589116 595758 595992 596193 604430 609962 614032 615772 618647 643072 643106 647352 650343 650388 650421 650425 650456 676397 684173 693642 697766 713569 713574 744307 757362 759896 760839 765232 771005 771033 775800 775814 776566 782629 786813 792005 792633 792655 807542 808461 808622 811393 812911 814736 814738 814741 814752 814757 814777 814778 814781 814800 814806 814808 814818 814825 814831 814841 814852 814867 814871 814876 814887 814888 814889 814894 814908 814911 814912 814914 814928 814929 814932 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brazzers tits"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"brazzers сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.92%) |
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.