Query Metrics
7
Database Queries
7
Different statements
186.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.41 ms (86.02%) |
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 491814 519235 532047 535493 538835 538954 540256 541360 541637 541639 541748 542487 543806 543807 544301 544327 544356 547333 547345 547568 548504 549269 549287 549299 549336 549337 549354 549355 549370 549391 549397 549401 549416 549896 549902 549921 549952 549970 549981 550044 550620 551937 551984 554346 556858 561586 564543 566973 570776 570786 570830 571185 572543 572575 572608 572639 574189 574201 574203 574282 574286 576693 577220 579917 579918 583643 583848 583853 583855 586828 586850 586924 592493 592539 614922 621703 624163 626558 629286 629902 634481 646799 647334 649996 667998 668158 668384 668420 670764 672092 673041 674005 674542 684268 686040 687114 690823 702888 703113 705289 707287 708101 711294 715676 720044 721726 722142 722698 729127 742515 744311 755465 756283 789016 805278 816088 816482 816498 817324 817959 ] |
||||||||||||||||||||||||||||||
|
16.01 ms (8.58%) |
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 624163 549287 549354 551984 572639 541637 549397 549391 570830 572543 715676 541639 538954 549337 707287 742515 816498 816482 817324 532047 535493 538835 541360 544327 549299 549902 550620 577220 543806 543807 547333 549952 561586 574203 549981 554346 572608 574286 579917 646799 668158 668420 686040 687114 705289 721726 647334 649996 670764 720044 548504 549269 549416 549896 549921 564543 571185 574201 583848 586924 586828 592493 614922 621703 626558 634481 586850 805278 789016 755465 729127 744311 756283 629286 629902 702888 703113 541748 576693 816088 817959 519235 540256 491814 547568 551937 566973 542487 549370 549970 550044 574189 574282 583855 544301 544356 549336 570776 667998 674542 708101 711294 668384 672092 673041 722142 722698 674005 684268 690823 547345 549355 549401 556858 570786 572575 579918 583643 583853 592539 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.32%) |
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 491814 519235 532047 535493 538835 538954 540256 541360 541637 541639 541748 542487 543806 543807 544301 544327 544356 547333 547345 547568 548504 549269 549287 549299 549336 549337 549354 549355 549370 549391 549397 549401 549416 549896 549902 549921 549952 549970 549981 550044 550620 551937 551984 554346 556858 561586 564543 566973 570776 570786 570830 571185 572543 572575 572608 572639 574189 574201 574203 574282 574286 576693 577220 579917 579918 583643 583848 583853 583855 586828 586850 586924 592493 592539 614922 621703 624163 626558 629286 629902 634481 646799 647334 649996 667998 668158 668384 668420 670764 672092 673041 674005 674542 684268 686040 687114 690823 702888 703113 705289 707287 708101 711294 715676 720044 721726 722142 722698 729127 742515 744311 755465 756283 789016 805278 816088 816482 816498 817324 817959 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"длинные порно фильмы"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"длинные порн фильм"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.92%) |
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.