Query Metrics
7
Database Queries
7
Different statements
167.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.39 ms (88.23%) |
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 370332 391590 392216 394006 395278 397294 397295 397641 397762 398195 400382 400713 401764 402473 402859 403166 404113 417821 427246 428574 433751 441479 441530 452907 499243 506526 518905 520764 534331 537245 540844 542042 545717 546057 549069 556166 568266 575560 575583 575606 590806 593560 594183 594267 594430 595447 598135 600945 602014 606365 610688 612718 620554 620805 620904 620978 633870 636049 639552 639959 645202 653343 656593 657143 658837 660338 660342 660444 660597 660713 662159 662204 669288 671529 680230 683092 683143 684887 687204 691217 696107 696111 700681 709037 712174 717235 717812 720028 720159 720362 725549 726164 728745 728755 736959 744907 748407 752595 756687 761778 762972 763493 767043 769075 770295 774650 776289 777652 778962 782842 785582 787172 787505 788550 791782 795684 805654 814019 824352 825018 ] |
||||||||||||||||||||||||||||||
|
10.70 ms (6.41%) |
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 656593 660338 680230 683092 691217 636049 594183 620805 633870 598135 639552 397641 398195 402473 824352 556166 778962 788550 748407 728745 728755 720028 400382 506526 394006 594430 657143 575606 370332 427246 520764 549069 653343 645202 662204 669288 696107 696111 709037 660342 610688 620554 620904 594267 712174 534331 662159 717812 782842 769075 787172 791782 441530 395278 545717 397295 452907 397294 397762 540844 546057 671529 720362 658837 660597 700681 717235 590806 752595 787505 726164 761778 762972 767043 725549 756687 736959 777652 639959 568266 402859 499243 575560 595447 602014 620978 404113 401764 575583 542042 403166 660713 660444 683143 684887 687204 606365 593560 600945 612718 392216 417821 428574 441479 776289 774650 785582 795684 805654 744907 763493 770295 720159 433751 391590 400713 814019 825018 518905 537245 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.42%) |
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 370332 391590 392216 394006 395278 397294 397295 397641 397762 398195 400382 400713 401764 402473 402859 403166 404113 417821 427246 428574 433751 441479 441530 452907 499243 506526 518905 520764 534331 537245 540844 542042 545717 546057 549069 556166 568266 575560 575583 575606 590806 593560 594183 594267 594430 595447 598135 600945 602014 606365 610688 612718 620554 620805 620904 620978 633870 636049 639552 639959 645202 653343 656593 657143 658837 660338 660342 660444 660597 660713 662159 662204 669288 671529 680230 683092 683143 684887 687204 691217 696107 696111 700681 709037 712174 717235 717812 720028 720159 720362 725549 726164 728745 728755 736959 744907 748407 752595 756687 761778 762972 763493 767043 769075 770295 774650 776289 777652 778962 782842 785582 787172 787505 788550 791782 795684 805654 814019 824352 825018 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen home made"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen домашн любительск"
]
|
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.