Query Metrics
7
Database Queries
7
Different statements
198.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.19 ms (86.87%) |
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 61726 187840 187964 188009 188240 188515 189743 191343 381752 381757 382971 383722 386044 386987 387951 388363 388729 388776 391155 391427 398567 400807 405859 408978 411737 450117 450122 450165 452856 453100 459830 463825 466885 466982 466989 467039 474836 474848 483355 487938 489323 506066 513785 515693 515723 518848 518875 518911 547029 549088 549216 549239 553472 554322 556066 559132 559344 559377 574384 578823 580340 604597 610034 633345 644881 660688 662898 677971 678778 678779 678790 678791 678795 678804 681666 698733 699385 715037 725177 726965 727049 728254 730315 732179 735028 735442 738296 738305 738320 744210 746162 766597 770115 770139 770187 770866 776312 780710 788981 794647 794732 795084 799358 802152 803019 804013 804590 804940 810775 814125 814621 817721 817963 824936 824938 824939 825038 826783 827259 827278 ] |
||||||||||||||||||||||||||||||
|
16.62 ms (8.39%) |
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 604597 474836 746162 489323 450165 580340 515723 405859 474848 559377 518848 388729 518875 549216 795084 715037 678778 382971 463825 467039 810775 513785 678791 453100 400807 678795 678790 518911 574384 824939 826783 794732 487938 804590 776312 559344 483355 827259 799358 770866 802152 391155 678779 678804 459830 549239 466989 825038 677971 738320 788981 644881 827278 411737 814125 633345 466982 381752 738305 744210 189743 381757 191343 388363 187964 610034 725177 727049 738296 699385 578823 553472 466885 398567 824938 817721 735028 391427 188515 814621 817963 824936 554322 662898 698733 804013 804940 735442 780710 388776 408978 803019 794647 726965 61726 506066 660688 728254 187840 556066 547029 732179 770115 386044 450117 549088 770139 386987 188009 515693 730315 387951 559132 383722 681666 770187 766597 450122 452856 188240 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.37%) |
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 61726 187840 187964 188009 188240 188515 189743 191343 381752 381757 382971 383722 386044 386987 387951 388363 388729 388776 391155 391427 398567 400807 405859 408978 411737 450117 450122 450165 452856 453100 459830 463825 466885 466982 466989 467039 474836 474848 483355 487938 489323 506066 513785 515693 515723 518848 518875 518911 547029 549088 549216 549239 553472 554322 556066 559132 559344 559377 574384 578823 580340 604597 610034 633345 644881 660688 662898 677971 678778 678779 678790 678791 678795 678804 681666 698733 699385 715037 725177 726965 727049 728254 730315 732179 735028 735442 738296 738305 738320 744210 746162 766597 770115 770139 770187 770866 776312 780710 788981 794647 794732 795084 799358 802152 803019 804013 804590 804940 810775 814125 814621 817721 817963 824936 824938 824939 825038 826783 827259 827278 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал бабушк"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"анальный секс старух"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал бабушк"
]
|
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.