Query Metrics
7
Database Queries
7
Different statements
173.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.53 ms (85.20%) |
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 13646 16831 33998 66768 88614 107606 117854 187611 187973 187974 188028 188169 188254 188258 188266 188515 191343 276696 358272 358437 381940 382085 384878 385606 385971 387296 387520 388204 388604 388792 390582 390624 390653 390987 392729 393087 394447 395515 395556 397224 397896 398459 398543 401186 406593 407387 407763 407910 409940 411338 411590 411688 417333 424325 427181 428053 448937 453921 454184 454887 456194 466653 468552 475884 479938 488894 489138 514353 522003 555064 558005 571144 589655 601122 612188 646289 665415 665440 665449 665873 667012 667578 667621 707484 710453 718981 721267 726810 726817 726838 726959 731787 733061 733085 733097 733098 733100 733128 734702 734705 734717 734728 737897 740162 742786 746060 754418 757233 757258 779352 780679 785941 788473 797235 797245 797259 799971 801133 808434 811491 ] |
||||||||||||||||||||||||||||||
|
14.44 ms (8.34%) |
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 381940 489138 387520 390987 382085 395556 276696 358437 358272 401186 409940 454887 454184 558005 718981 737897 384878 522003 33998 117854 188515 456194 707484 721267 667621 589655 785941 788473 797259 808434 734705 726810 726959 733097 733098 746060 757233 733128 734717 734728 742786 780679 191343 398459 188169 407763 799971 390582 66768 754418 13646 88614 407387 424325 428053 388604 411688 417333 479938 448937 453921 488894 390624 388792 395515 397224 667012 667578 665440 665873 555064 779352 797245 726817 733100 734702 733061 733085 757258 740162 187973 187974 385971 187611 16831 665449 797235 388204 188266 392729 390653 406593 514353 571144 665415 811491 726838 411338 397896 475884 188028 394447 407910 468552 466653 612188 731787 107606 710453 646289 601122 801133 385606 188254 188258 393087 387296 398543 411590 427181 ] |
||||||||||||||||||||||||||||||
|
4.24 ms (2.45%) |
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 13646 16831 33998 66768 88614 107606 117854 187611 187973 187974 188028 188169 188254 188258 188266 188515 191343 276696 358272 358437 381940 382085 384878 385606 385971 387296 387520 388204 388604 388792 390582 390624 390653 390987 392729 393087 394447 395515 395556 397224 397896 398459 398543 401186 406593 407387 407763 407910 409940 411338 411590 411688 417333 424325 427181 428053 448937 453921 454184 454887 456194 466653 468552 475884 479938 488894 489138 514353 522003 555064 558005 571144 589655 601122 612188 646289 665415 665440 665449 665873 667012 667578 667621 707484 710453 718981 721267 726810 726817 726838 726959 731787 733061 733085 733097 733098 733100 733128 734702 734705 734717 734728 737897 740162 742786 746060 754418 757233 757258 779352 780679 785941 788473 797235 797245 797259 799971 801133 808434 811491 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"a mature blonde"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature беловолосая"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature беловолосая"
]
|
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.