Query Metrics
7
Database Queries
7
Different statements
188.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.15 ms (84.56%) |
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 538949 540203 541368 541587 541632 541633 541646 541833 541871 541888 542188 542480 542954 542961 543480 543496 544296 544472 544478 550020 554205 554784 554786 554787 556987 559051 559119 559378 560085 560924 562831 563419 566243 566688 566702 571028 571428 571442 573763 573765 574244 574258 576631 576638 576639 576680 576686 576691 576698 576699 576704 576705 576707 576710 576720 576723 576726 577357 577363 577374 577384 580254 580258 581266 581295 581300 581398 583832 583860 583885 587817 590954 592003 592376 592388 592437 592440 592492 592530 593365 598348 598407 603147 603247 603273 610047 614745 615738 615740 615743 615748 615751 617814 619082 619394 619468 620130 620148 620153 620157 621305 621306 621691 622364 622373 622381 622382 622953 624154 624155 636268 644005 648204 648256 671735 671737 671764 673537 690783 715670 ] |
||||||||||||||||||||||||||||||
|
18.16 ms (9.65%) |
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 617814 577363 563419 576680 576639 576705 671737 592388 583860 603273 592003 542954 541888 541587 541633 576726 541833 542188 576710 571428 544296 543496 574244 566688 610047 619394 622364 559119 542961 554784 544478 576638 576723 554205 574258 636268 621691 560924 581266 673537 581295 592492 592376 559051 583832 541368 587817 621306 577357 671764 615743 540203 573763 593365 620153 622382 615738 615751 554786 550020 538949 576699 598348 562831 566702 541632 556987 544472 690783 541646 671735 590954 621305 576707 543480 715670 580254 615740 615748 576698 577374 619082 571442 580258 576631 619468 620148 624154 542480 648204 576686 560085 648256 644005 622373 620130 592530 583885 592440 581300 592437 622953 624155 577384 598407 603147 622381 541871 614745 581398 554787 573765 566243 576704 620157 576691 603247 559378 576720 571028 ] |
||||||||||||||||||||||||||||||
|
3.54 ms (1.88%) |
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 538949 540203 541368 541587 541632 541633 541646 541833 541871 541888 542188 542480 542954 542961 543480 543496 544296 544472 544478 550020 554205 554784 554786 554787 556987 559051 559119 559378 560085 560924 562831 563419 566243 566688 566702 571028 571428 571442 573763 573765 574244 574258 576631 576638 576639 576680 576686 576691 576698 576699 576704 576705 576707 576710 576720 576723 576726 577357 577363 577374 577384 580254 580258 581266 581295 581300 581398 583832 583860 583885 587817 590954 592003 592376 592388 592437 592440 592492 592530 593365 598348 598407 603147 603247 603273 610047 614745 615738 615740 615743 615748 615751 617814 619082 619394 619468 620130 620148 620153 620157 621305 621306 621691 622364 622373 622381 622382 622953 624154 624155 636268 644005 648204 648256 671735 671737 671764 673537 690783 715670 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"retro sex films"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ретр секс фильм"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ретр секс фильм"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.