Query Metrics
7
Database Queries
7
Different statements
145.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.18 ms (83.98%) |
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 248084 265677 285404 382107 383299 384974 397516 401581 406852 425904 446329 472937 473107 477883 529899 530323 532050 532067 532086 533022 533204 533211 537562 537691 537721 537756 539597 540446 544332 544337 547305 547308 547310 547314 547328 549273 549307 549328 549348 549365 549371 549377 549385 549386 549389 549392 549911 549933 549938 549957 549961 549965 549971 550330 551706 554068 557521 559128 570772 570774 570827 570828 570952 572564 572576 572578 572585 572611 572630 572670 572765 574176 574227 579918 579938 579950 581427 591165 603279 614294 629901 629902 629936 638560 643084 653258 669481 678570 690831 691521 692198 692222 692231 692803 693059 694541 695196 699764 715438 730221 737792 757918 765818 781122 781155 812419 ] |
||||||||||||||||||||||||||||||
|
12.71 ms (8.74%) |
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 629902 549385 570774 384974 406852 533022 547310 549911 572578 549389 544332 692222 692803 669481 678570 549386 579918 638560 730221 248084 549938 629901 540446 532050 547305 549965 570828 579950 544337 549273 694541 699764 547308 549957 572611 574227 781122 812419 737792 781155 382107 401581 537721 533211 549961 533204 532086 530323 547314 549348 572564 549307 570772 653258 692231 603279 383299 537562 554068 539597 537756 549328 549971 570827 551706 715438 549392 572576 572585 614294 285404 473107 397516 549365 572670 572630 629936 765818 757918 446329 550330 579938 265677 691521 477883 529899 532067 537691 549377 559128 547328 574176 549933 695196 572765 581427 591165 643084 690831 557521 570952 693059 692198 425904 549371 472937 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (2.15%) |
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 248084 265677 285404 382107 383299 384974 397516 401581 406852 425904 446329 472937 473107 477883 529899 530323 532050 532067 532086 533022 533204 533211 537562 537691 537721 537756 539597 540446 544332 544337 547305 547308 547310 547314 547328 549273 549307 549328 549348 549365 549371 549377 549385 549386 549389 549392 549911 549933 549938 549957 549961 549965 549971 550330 551706 554068 557521 559128 570772 570774 570827 570828 570952 572564 572576 572578 572585 572611 572630 572670 572765 574176 574227 579918 579938 579950 581427 591165 603279 614294 629901 629902 629936 638560 643084 653258 669481 678570 690831 691521 692198 692222 692231 692803 693059 694541 695196 699764 715438 730221 737792 757918 765818 781122 781155 812419 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"scene erotic"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.33%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"scene эротик"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"scene эротик"
]
|
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.