Query Metrics
7
Database Queries
7
Different statements
163.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.85 ms (83.32%) |
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 382061 392987 392989 401398 419839 426006 441646 447337 449327 449333 454332 454855 456807 467880 474864 482636 483925 490060 495639 496108 496854 503342 507013 507947 513092 513682 517385 539548 548085 548879 553240 555076 556844 556871 559301 562758 564461 566833 572508 573286 576290 577594 585950 586266 593915 601602 603294 605207 613263 614805 616733 623512 627063 650514 666418 666432 672878 675148 676927 677899 684489 689937 696865 716247 724609 726468 726503 726582 730249 730396 730806 733274 734345 734466 736402 739938 740611 744140 744169 744829 746367 750469 757285 757973 759738 762884 764153 767957 775068 775587 776503 785672 785722 788811 788877 791095 792348 792892 794736 795045 795078 800148 800185 803451 804360 806090 814289 814376 816188 818455 818521 820149 820317 820489 822295 824601 825054 826350 827083 827377 ] |
||||||||||||||||||||||||||||||
|
15.99 ms (9.81%) |
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 788877 775587 757285 739938 827083 795045 795078 800148 740611 507013 447337 483925 496854 562758 382061 818521 820489 744169 744829 746367 806090 696865 764153 401398 454855 490060 613263 827377 816188 792348 785672 744140 804360 392987 820317 820149 824601 826350 539548 800185 814376 449333 566833 392989 419839 441646 426006 818455 684489 822295 825054 814289 482636 449327 454332 456807 467880 474864 507947 517385 503342 513682 495639 496108 513092 559301 572508 576290 573286 564461 577594 650514 666418 675148 677899 689937 716247 676927 666432 672878 548085 548879 553240 555076 556844 556871 593915 601602 605207 586266 603294 616733 585950 614805 623512 627063 775068 791095 776503 792892 803451 724609 726503 733274 734345 734466 785722 788811 794736 730249 730806 736402 750469 757973 759738 762884 767957 726468 726582 730396 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.85%) |
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 382061 392987 392989 401398 419839 426006 441646 447337 449327 449333 454332 454855 456807 467880 474864 482636 483925 490060 495639 496108 496854 503342 507013 507947 513092 513682 517385 539548 548085 548879 553240 555076 556844 556871 559301 562758 564461 566833 572508 573286 576290 577594 585950 586266 593915 601602 603294 605207 613263 614805 616733 623512 627063 650514 666418 666432 672878 675148 676927 677899 684489 689937 696865 716247 724609 726468 726503 726582 730249 730396 730806 733274 734345 734466 736402 739938 740611 744140 744169 744829 746367 750469 757285 757973 759738 762884 764153 767957 775068 775587 776503 785672 785722 788811 788877 791095 792348 792892 794736 795045 795078 800148 800185 803451 804360 806090 814289 814376 816188 818455 818521 820149 820317 820489 822295 824601 825054 826350 827083 827377 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.66%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза pussy"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"licking-pussy"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лиза pussy"
]
|
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.