Query Metrics
7
Database Queries
7
Different statements
409.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.69 ms (50.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"threesome hardcore"
]
|
||||||||||||||||||||||||||||||
|
176.67 ms (43.17%) |
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 95742 96347 96452 96872 96947 97688 114360 118086 118234 118237 196316 249926 260962 348158 359918 381771 382051 384793 384809 385948 386016 386226 387899 388681 389482 390533 393751 394187 395440 395707 396504 397766 398217 398317 398908 400935 401134 401655 401728 401837 402016 402151 402555 402885 403067 409144 409379 409894 410937 411284 412081 415722 417486 431904 462788 471896 475930 477593 478463 478779 494151 495750 499894 505102 506279 509501 510821 513893 515143 516818 524213 525020 530310 530372 530854 531236 532833 543124 555783 565539 584008 588899 600269 604523 633147 635833 639731 645230 665916 667197 667276 677766 682478 686712 688105 695224 707292 720289 728385 743893 777039 789529 793376 801931 806346 807516 807554 811013 814313 816235 817762 818387 818460 819565 819579 821409 825119 827849 827949 827956 ] |
||||||||||||||||||||||||||||||
|
16.47 ms (4.02%) |
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 394187 409894 555783 531236 639731 403067 417486 827949 777039 395707 477593 96947 509501 505102 471896 695224 635833 807516 806346 743893 411284 96872 260962 409379 816235 513893 686712 807554 789529 118237 398908 395440 402016 530372 118234 114360 688105 401655 384793 495750 415722 720289 409144 525020 401837 811013 728385 385948 410937 384809 588899 827849 827956 604523 412081 524213 494151 478779 478463 793376 677766 393751 530854 707292 510821 390533 565539 667197 682478 388681 506279 249926 398217 818460 475930 401134 118086 386016 386226 95742 97688 382051 96347 387899 402151 814313 819579 825119 499894 532833 584008 665916 600269 96452 397766 398317 396504 402885 515143 348158 381771 431904 818387 819565 817762 530310 462788 667276 645230 801931 633147 401728 516818 543124 196316 359918 389482 400935 402555 821409 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (0.78%) |
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 95742 96347 96452 96872 96947 97688 114360 118086 118234 118237 196316 249926 260962 348158 359918 381771 382051 384793 384809 385948 386016 386226 387899 388681 389482 390533 393751 394187 395440 395707 396504 397766 398217 398317 398908 400935 401134 401655 401728 401837 402016 402151 402555 402885 403067 409144 409379 409894 410937 411284 412081 415722 417486 431904 462788 471896 475930 477593 478463 478779 494151 495750 499894 505102 506279 509501 510821 513893 515143 516818 524213 525020 530310 530372 530854 531236 532833 543124 555783 565539 584008 588899 600269 604523 633147 635833 639731 645230 665916 667197 667276 677766 682478 686712 688105 695224 707292 720289 728385 743893 777039 789529 793376 801931 806346 807516 807554 811013 814313 816235 817762 818387 818460 819565 819579 821409 825119 827849 827949 827956 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (0.51%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс втро хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.