Query Metrics
7
Database Queries
7
Different statements
172.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.45 ms (85.62%) |
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 384223 385478 388925 390214 406022 406125 406488 415718 420426 420454 421598 422231 422397 423352 423639 429818 431228 434573 443958 450754 453517 456188 459269 460936 460962 470334 476956 478765 482237 487475 496510 499912 509268 512004 523044 524206 528369 528609 542289 543194 543218 549508 550638 552334 552932 553107 553110 553239 555947 564650 565328 567387 573795 579213 579342 579944 585847 590242 593116 598499 598965 599903 600058 604084 604137 605380 608426 624285 624879 631109 646244 646254 649226 650230 653270 657066 663332 664852 673860 677015 677349 679306 682388 683787 685823 698293 715228 715920 717056 720223 724556 725110 731893 731907 735610 740653 741193 742833 743079 746802 746958 750015 754199 758528 758557 768130 773580 773821 780467 782057 785719 786383 799095 799367 799980 803090 809125 816503 825465 827299 ] |
||||||||||||||||||||||||||||||
|
14.56 ms (8.46%) |
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 384223 420454 523044 423639 825465 542289 543194 663332 677015 593116 605380 782057 758557 698293 406488 524206 406022 677349 600058 773580 754199 741193 431228 649226 456188 421598 420426 827299 816503 496510 579944 553110 565328 579213 646254 679306 552334 553239 598499 631109 780467 476956 423352 509268 528369 528609 598965 450754 585847 434573 550638 653270 590242 742833 746802 487475 573795 673860 459269 388925 390214 567387 717056 599903 786383 725110 735610 385478 555947 579342 470334 415718 724556 429818 543218 604084 604137 809125 740653 406125 482237 443958 422231 499912 512004 460962 650230 715228 646244 664852 682388 720223 799367 731907 758528 785719 731893 743079 750015 768130 715920 803090 422397 460936 683787 564650 552932 549508 685823 799095 773821 624879 478765 453517 553107 657066 608426 624285 799980 746958 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.72%) |
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 384223 385478 388925 390214 406022 406125 406488 415718 420426 420454 421598 422231 422397 423352 423639 429818 431228 434573 443958 450754 453517 456188 459269 460936 460962 470334 476956 478765 482237 487475 496510 499912 509268 512004 523044 524206 528369 528609 542289 543194 543218 549508 550638 552334 552932 553107 553110 553239 555947 564650 565328 567387 573795 579213 579342 579944 585847 590242 593116 598499 598965 599903 600058 604084 604137 605380 608426 624285 624879 631109 646244 646254 649226 650230 653270 657066 663332 664852 673860 677015 677349 679306 682388 683787 685823 698293 715228 715920 717056 720223 724556 725110 731893 731907 735610 740653 741193 742833 743079 746802 746958 750015 754199 758528 758557 768130 773580 773821 780467 782057 785719 786383 799095 799367 799980 803090 809125 816503 825465 827299 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob cute"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс cute"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс cute"
]
|
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.