Query Metrics
7
Database Queries
7
Different statements
205.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.81 ms (86.99%) |
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 445928 480390 530724 530725 530728 530730 532262 532265 532356 532359 534227 534232 534240 534243 534248 534253 534255 534256 534259 534260 534262 534269 534276 534278 534281 534287 534294 534297 534299 534304 534308 534310 534314 534318 534319 534322 534330 534780 534810 534851 535014 535020 535373 535825 535828 535829 535831 535837 537107 537111 540943 554753 564765 584717 585127 585129 586668 586672 586678 587180 596108 604430 607191 614032 618647 629417 632988 637207 640692 640699 649171 650338 650339 650343 650388 650401 651025 651611 676397 682803 713556 713574 717720 756415 757362 759896 760839 765232 768986 769901 771005 782629 790854 792633 797646 800867 802654 811393 814734 814752 814769 814773 814777 814779 814789 814809 814838 814841 814843 814852 814853 814866 814876 814887 814893 814894 814906 814910 814922 ] |
||||||||||||||||||||||||||||||
|
16.47 ms (8.01%) |
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 814922 814773 534232 532265 532356 534308 535831 537111 650338 713556 607191 629417 637207 814789 585127 814910 534281 534310 534318 534259 534314 535828 535837 713574 814777 814838 534380 534278 534240 564765 618647 811393 535014 535829 530730 650388 717720 554753 604430 614032 800867 771005 632988 585129 814809 534294 814893 535825 534330 651611 640692 586668 596108 640699 534322 814734 814853 814769 814866 532262 534248 534256 534227 534780 534243 682803 586678 587180 765232 769901 814894 814841 445928 534287 534304 534319 530728 534262 534269 534299 534255 584717 756415 768986 814752 814779 530725 530724 534276 534810 532359 534297 650343 676397 650339 586672 782629 759896 757362 790854 792633 535020 814843 814887 814906 814852 814876 480390 534851 534260 537107 534253 535373 540943 649171 650401 651025 760839 797646 802654 ] |
||||||||||||||||||||||||||||||
|
3.16 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 445928 480390 530724 530725 530728 530730 532262 532265 532356 532359 534227 534232 534240 534243 534248 534253 534255 534256 534259 534260 534262 534269 534276 534278 534281 534287 534294 534297 534299 534304 534308 534310 534314 534318 534319 534322 534330 534780 534810 534851 535014 535020 535373 535825 535828 535829 535831 535837 537107 537111 540943 554753 564765 584717 585127 585129 586668 586672 586678 587180 596108 604430 607191 614032 618647 629417 632988 637207 640692 640699 649171 650338 650339 650343 650388 650401 651025 651611 676397 682803 713556 713574 717720 756415 757362 759896 760839 765232 768986 769901 771005 782629 790854 792633 797646 800867 802654 811393 814734 814752 814769 814773 814777 814779 814789 814809 814838 814841 814843 814852 814853 814866 814876 814887 814893 814894 814906 814910 814922 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brazzers sex"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"brazzers секс"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.78%) |
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.