Query Metrics
7
Database Queries
7
Different statements
167.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.91 ms (83.58%) |
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 429181 429729 445274 446108 451531 453862 457078 482359 486470 517743 528761 530385 530697 530798 531134 531179 531233 531256 531258 532744 532965 533016 533044 533521 533798 533855 534216 534647 534992 534999 536287 536289 536542 536606 536620 537776 537880 537886 537890 537932 538881 540330 541925 542877 544854 545418 545718 550200 570691 597236 597254 599851 599894 599928 599958 600017 600175 600329 601609 617421 630547 630806 631199 631203 631948 632586 632638 632658 632660 632684 634154 634786 636316 636991 637089 637096 637107 637120 637431 637432 639048 639257 639335 639792 639797 640795 644940 645973 646448 648850 648862 651620 651669 666585 672329 676066 677295 679326 679721 679742 679757 679761 679772 679785 680115 680150 680153 696229 699627 704216 704226 708444 716085 716870 733843 733849 733863 733883 748236 758180 ] |
||||||||||||||||||||||||||||||
|
17.31 ms (10.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 599928 600175 599851 758180 457078 534216 534647 534992 536542 537776 531134 533016 536620 531179 531233 531256 532744 533855 537880 537890 531258 532965 536606 537886 537932 542877 550200 570691 645973 679785 696229 699627 716870 666585 680115 704216 708444 648862 679761 680150 680153 597254 599894 632638 634154 637107 637431 637432 639048 639335 639792 640795 600329 601609 632658 632684 636991 637089 637096 637120 632660 636316 639797 597236 600017 632586 733849 733883 733843 634786 716085 446108 429181 453862 486470 530697 631203 445274 528761 533521 533044 534999 482359 679772 648850 651620 704226 599958 630806 631199 733863 748236 631948 451531 544854 672329 651669 630547 639257 545718 545418 646448 617421 540330 679742 676066 536289 530798 538881 541925 677295 679721 679326 679757 517743 429729 644940 530385 533798 536287 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.68%) |
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 429181 429729 445274 446108 451531 453862 457078 482359 486470 517743 528761 530385 530697 530798 531134 531179 531233 531256 531258 532744 532965 533016 533044 533521 533798 533855 534216 534647 534992 534999 536287 536289 536542 536606 536620 537776 537880 537886 537890 537932 538881 540330 541925 542877 544854 545418 545718 550200 570691 597236 597254 599851 599894 599928 599958 600017 600175 600329 601609 617421 630547 630806 631199 631203 631948 632586 632638 632658 632660 632684 634154 634786 636316 636991 637089 637096 637107 637120 637431 637432 639048 639257 639335 639792 639797 640795 644940 645973 646448 648850 648862 651620 651669 666585 672329 676066 677295 679326 679721 679742 679757 679761 679772 679785 680115 680150 680153 696229 699627 704216 704226 708444 716085 716870 733843 733849 733863 733883 748236 758180 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"кастинг трахают толпо…"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кастинг секс группов секс"
]
|
||||||||||||||||||||||||||||||
|
1.54 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.