Query Metrics
7
Database Queries
7
Different statements
407.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
380.44 ms (93.36%) |
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 419008 424238 429455 429782 431954 433220 433829 434156 435346 437383 437876 438114 441366 441929 442402 442416 444067 444184 444429 444620 450530 453437 453801 454876 454929 455653 455787 456300 458179 459580 459865 459866 460421 460694 461337 461348 461596 463344 463654 464082 464516 464694 465162 465738 472145 473616 476013 476405 477235 478743 478861 479164 479558 479632 480960 483032 483051 483056 483172 486633 491177 491332 495002 495088 499951 500010 501397 502604 502938 502988 505161 505526 506615 507904 508309 508549 509819 510016 510203 511602 512738 516425 519024 519664 526092 526602 526996 527675 527788 527965 528550 534494 534512 542284 552460 555563 555930 557361 560002 567181 567194 581721 582330 582382 584560 594152 596642 597198 598198 599150 599376 599421 599713 621055 624390 626153 628653 676424 813127 ] |
||||||||||||||||||||||||||||||
|
17.45 ms (4.28%) |
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 438114 444067 454876 459580 464516 477235 444429 459866 459987 463654 465738 478861 442402 442416 472145 478743 500010 502938 491332 534512 483056 486633 508309 508549 527675 483051 506615 519664 594152 624390 528550 526996 476405 495002 424238 441366 444620 419008 434156 429782 453437 464082 473616 491177 450530 459865 479164 454929 507904 534494 502604 510203 519024 505526 526602 461337 461348 581721 582330 542284 557361 567181 567194 560002 676424 552460 555563 555930 582382 584560 597198 599376 598198 599421 626153 599150 599713 628653 596642 621055 813127 455787 460421 460694 479632 433220 433829 437876 453801 480960 431954 435346 441929 444184 458179 461596 464694 479558 429455 456300 463344 437383 455653 465162 476013 499951 505161 509819 510016 511602 512738 516425 527788 483172 502988 526092 527965 483032 495088 501397 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (0.58%) |
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 419008 424238 429455 429782 431954 433220 433829 434156 435346 437383 437876 438114 441366 441929 442402 442416 444067 444184 444429 444620 450530 453437 453801 454876 454929 455653 455787 456300 458179 459580 459865 459866 460421 460694 461337 461348 461596 463344 463654 464082 464516 464694 465162 465738 472145 473616 476013 476405 477235 478743 478861 479164 479558 479632 480960 483032 483051 483056 483172 486633 491177 491332 495002 495088 499951 500010 501397 502604 502938 502988 505161 505526 506615 507904 508309 508549 509819 510016 510203 511602 512738 516425 519024 519664 526092 526602 526996 527675 527788 527965 528550 534494 534512 542284 552460 555563 555930 557361 560002 567181 567194 581721 582330 582382 584560 594152 596642 597198 598198 599150 599376 599421 599713 621055 624390 626153 628653 676424 813127 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (0.56%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов step sister"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov step sister"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.39%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов step sister"
]
|
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.