Query Metrics
7
Database Queries
7
Different statements
156.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.64 ms (84.16%) |
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 22861 183126 382246 382942 385829 395597 395999 397129 398275 401851 402062 406334 408172 410132 413732 417650 417660 418428 418528 418646 419950 420192 422623 422653 423068 425366 428458 429569 431607 431672 445233 446355 453302 456625 456636 459229 459234 473060 473755 483230 485577 497235 500680 500708 510168 510578 510595 512197 512216 512220 516452 516811 516853 524387 534198 540201 540213 542648 543919 545532 546039 546292 550639 550772 550996 551086 551972 551978 551993 552897 552933 555904 556362 557543 557815 559162 559869 559882 559902 559914 566014 572746 577184 591795 593431 597275 600623 600806 614079 615005 622639 636883 643379 650955 653240 653247 662078 673050 689688 702497 713113 717892 717921 720948 721756 727853 741106 743038 753962 754812 758493 766781 788807 789860 793657 799871 800071 802831 822535 825750 ] |
||||||||||||||||||||||||||||||
|
14.83 ms (9.48%) |
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 766781 721756 615005 800071 417660 650955 822535 653247 720948 428458 395597 418428 653240 643379 753962 425366 419950 413732 546039 550639 551978 550772 417650 510595 395999 446355 429569 510578 600806 593431 445233 397129 459234 591795 500708 516853 557815 614079 540201 540213 717892 662078 673050 546292 622639 799871 802831 727853 741106 485577 542648 551086 559914 183126 423068 456636 557543 459229 545532 600623 418646 512220 551972 552897 456625 524387 401851 422653 516811 398275 473755 512197 500680 550996 577184 566014 825750 743038 543919 555904 382246 534198 552933 556362 406334 431607 510168 516452 559882 689688 702497 713113 572746 636883 793657 789860 422623 410132 758493 483230 402062 385829 382942 453302 559869 420192 408172 497235 559902 717921 754812 597275 788807 551993 559162 22861 418528 473060 512216 431672 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (1.99%) |
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 22861 183126 382246 382942 385829 395597 395999 397129 398275 401851 402062 406334 408172 410132 413732 417650 417660 418428 418528 418646 419950 420192 422623 422653 423068 425366 428458 429569 431607 431672 445233 446355 453302 456625 456636 459229 459234 473060 473755 483230 485577 497235 500680 500708 510168 510578 510595 512197 512216 512220 516452 516811 516853 524387 534198 540201 540213 542648 543919 545532 546039 546292 550639 550772 550996 551086 551972 551978 551993 552897 552933 555904 556362 557543 557815 559162 559869 559882 559902 559914 566014 572746 577184 591795 593431 597275 600623 600806 614079 615005 622639 636883 643379 650955 653240 653247 662078 673050 689688 702497 713113 717892 717921 720948 721756 727853 741106 743038 753962 754812 758493 766781 788807 789860 793657 799871 800071 802831 822535 825750 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian blow job"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.