Query Metrics
7
Database Queries
7
Different statements
600.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.57 ms (35.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин full"
]
|
||||||||||||||||||||||||||||||
|
207.32 ms (34.50%) |
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 413126 419989 424695 424926 425961 429610 430635 430661 442189 442276 442301 442325 442831 451940 451943 451950 451957 451983 452008 452039 452081 452086 452092 452126 452132 452133 452135 452170 452284 452813 453835 456164 456791 459406 460026 465698 466373 466850 467859 468846 480270 481173 500980 502485 506942 507810 508254 512941 519318 519894 520617 522191 523053 523422 523769 523775 523791 529704 530345 532161 535164 537115 537240 537531 541606 541630 541642 541644 541656 541671 541698 541712 541749 541780 541830 541833 541885 542193 542194 542969 550634 552281 555798 559172 560788 564767 565612 566074 566606 571785 575329 577661 579138 580401 583533 584092 584703 586675 586684 591094 599525 606946 610560 629961 633132 633136 637592 640698 640723 646872 650456 675476 742663 771453 783452 784112 794247 802791 805630 814921 ] |
||||||||||||||||||||||||||||||
|
155.49 ms (25.88%) |
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 413126 419989 424695 424926 425961 429610 430635 430661 442189 442276 442301 442325 442831 451940 451943 451950 451957 451983 452008 452039 452081 452086 452092 452126 452132 452133 452135 452170 452284 452813 453835 456164 456791 459406 460026 465698 466373 466850 467859 468846 480270 481173 500980 502485 506942 507810 508254 512941 519318 519894 520617 522191 523053 523422 523769 523775 523791 529704 530345 532161 535164 537115 537240 537531 541606 541630 541642 541644 541656 541671 541698 541712 541749 541780 541830 541833 541885 542193 542194 542969 550634 552281 555798 559172 560788 564767 565612 566074 566606 571785 575329 577661 579138 580401 583533 584092 584703 586675 586684 591094 599525 606946 610560 629961 633132 633136 637592 640698 640723 646872 650456 675476 742663 771453 783452 784112 794247 802791 805630 814921 ] |
||||||||||||||||||||||||||||||
|
17.56 ms (2.92%) |
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 452008 480270 629961 451957 541833 542193 413126 442276 452135 508254 519894 523053 529704 523422 537115 550634 566074 571785 650456 646872 575329 784112 742663 633136 640698 467859 442325 452284 519318 541712 555798 541656 637592 451943 452813 500980 502485 442301 429610 541606 424926 814921 452039 452086 452132 452170 465698 468846 523775 532161 542969 566606 640723 424695 419989 451950 481173 523769 541780 541642 541644 541698 542194 541749 583533 459406 452133 453835 456791 523791 530345 507810 520617 537240 537531 506942 466850 559172 565612 584092 552281 579138 564767 577661 580401 675476 599525 633132 586675 586684 610560 606946 794247 802791 805630 783452 771453 466373 452126 460026 442189 522191 541830 541885 560788 430635 541630 541671 451983 451940 512941 584703 591094 452092 430661 456164 442831 425961 452081 535164 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother full"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин full"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.24%) |
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.