Query Metrics
7
Database Queries
7
Different statements
188.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.44 ms (83.74%) |
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 33260 151564 233532 261144 403049 407422 417080 445633 451458 453096 454226 454559 460768 464936 466312 466350 470424 475051 486798 490195 490801 490877 491399 516473 518576 521217 521228 526477 530325 532054 532818 539654 541781 544362 547934 549243 549370 549385 560485 563214 563217 565648 566558 566982 583643 615554 620134 620169 621610 622137 622370 629847 687105 706339 714199 718279 721155 721830 725350 728229 729884 732358 732805 733148 734016 743129 746097 746547 748232 754660 756103 765306 769923 770192 772459 775573 779613 788169 788865 793587 796268 797754 800190 800205 800925 801192 801226 801746 801868 803228 805587 808662 809421 813773 814926 815167 815190 815254 815442 815460 815579 815625 815944 816276 817277 817845 817910 817940 818360 818419 818901 820126 820366 820685 820689 820717 821093 821532 823620 824520 ] |
||||||||||||||||||||||||||||||
|
16.70 ms (8.88%) |
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 815460 815625 820685 815579 816276 821093 530325 490801 544362 549370 565648 687105 718279 721155 566982 583643 622370 622137 775573 803228 808662 729884 732358 734016 746097 746547 801192 743129 754660 779613 788865 797754 491399 453096 470424 454226 516473 475051 417080 466350 460768 820689 817277 824520 820366 621610 796268 800925 233532 464936 547934 563217 541781 451458 445633 518576 33260 407422 732805 815442 814926 815190 820126 821532 486798 566558 560485 714199 721830 563214 615554 800205 801226 809421 772459 728229 769923 733148 748232 770192 756103 620134 620169 629847 800190 805587 454559 261144 466312 526477 490195 490877 549243 817910 815167 539654 549385 706339 801746 801868 725350 788169 151564 532818 765306 793587 403049 521228 813773 817845 818360 818419 818901 823620 815254 815944 817940 820717 521217 532054 ] |
||||||||||||||||||||||||||||||
|
6.32 ms (3.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"kissing mature woman"
]
|
||||||||||||||||||||||||||||||
|
2.54 ms (1.35%) |
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 33260 151564 233532 261144 403049 407422 417080 445633 451458 453096 454226 454559 460768 464936 466312 466350 470424 475051 486798 490195 490801 490877 491399 516473 518576 521217 521228 526477 530325 532054 532818 539654 541781 544362 547934 549243 549370 549385 560485 563214 563217 565648 566558 566982 583643 615554 620134 620169 621610 622137 622370 629847 687105 706339 714199 718279 721155 721830 725350 728229 729884 732358 732805 733148 734016 743129 746097 746547 748232 754660 756103 765306 769923 770192 772459 775573 779613 788169 788865 793587 796268 797754 800190 800205 800925 801192 801226 801746 801868 803228 805587 808662 809421 813773 814926 815167 815190 815254 815442 815460 815579 815625 815944 816276 817277 817845 817910 817940 818360 818419 818901 820126 820366 820685 820689 820717 821093 821532 823620 824520 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"kissing зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"kissing зрелая женщин"
]
|
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.