Query Metrics
7
Database Queries
7
Different statements
156.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.72 ms (83.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 233292 392054 400179 401196 413089 419093 428143 428810 429492 432663 437797 439627 444379 446901 449089 449719 450649 454540 454989 455281 457856 459143 460746 464561 464663 469486 470762 471849 476332 477327 477392 481805 482251 485271 486536 490413 491061 493171 500725 509392 518147 519046 519137 521476 524314 526008 529496 530329 531528 534190 536353 542908 549822 554579 555077 557049 560989 561409 563924 565679 568368 572210 585728 588942 597047 603458 609584 610058 614089 623392 672251 682269 683460 687663 703467 705256 710595 723981 725197 726470 726598 726845 730524 731916 737618 742497 742839 743809 748689 758443 759105 759740 765023 771139 786167 788282 790803 793526 795033 795041 800234 802185 802274 807805 808012 810062 810069 810819 812634 814895 817737 819916 819919 820126 824125 824229 825101 826267 827264 827577 ] |
||||||||||||||||||||||||||||||
|
16.45 ms (10.49%) |
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 742497 428810 817737 603458 808012 429492 444379 469486 623392 726598 743809 531528 824125 687663 771139 703467 449719 683460 470762 554579 814895 530329 705256 588942 723981 800234 730524 731916 542908 682269 536353 509392 400179 526008 500725 481805 568368 795033 555077 810069 401196 439627 413089 464663 524314 563924 710595 560989 812634 802185 742839 790803 765023 726470 725197 482251 437797 454540 521476 428143 446901 486536 419093 477392 449089 672251 609584 471849 786167 565679 392054 826267 795041 459143 519137 490413 819919 561409 597047 807805 726845 759740 610058 810062 737618 477327 519046 457856 534190 557049 529496 585728 758443 455281 788282 233292 450649 493171 432663 820126 518147 819916 827264 827577 825101 572210 793526 810819 759105 454989 802274 824229 476332 491061 464561 549822 485271 460746 614089 748689 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.80%) |
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 233292 392054 400179 401196 413089 419093 428143 428810 429492 432663 437797 439627 444379 446901 449089 449719 450649 454540 454989 455281 457856 459143 460746 464561 464663 469486 470762 471849 476332 477327 477392 481805 482251 485271 486536 490413 491061 493171 500725 509392 518147 519046 519137 521476 524314 526008 529496 530329 531528 534190 536353 542908 549822 554579 555077 557049 560989 561409 563924 565679 568368 572210 585728 588942 597047 603458 609584 610058 614089 623392 672251 682269 683460 687663 703467 705256 710595 723981 725197 726470 726598 726845 730524 731916 737618 742497 742839 743809 748689 758443 759105 759740 765023 771139 786167 788282 790803 793526 795033 795041 800234 802185 802274 807805 808012 810062 810069 810819 812634 814895 817737 819916 819919 820126 824125 824229 825101 826267 827264 827577 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ÐéÐÇð░Ðàð░ðÁÐé Ðüð┐ÐÅÐëÐâÐÄ ð╝ð░ð╝ð░ÐêÐ%ÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс спящ мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.84%) |
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.