Query Metrics
7
Database Queries
7
Different statements
182.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.34 ms (86.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 21981 183044 263144 370755 382295 395583 400162 401799 409916 411344 411691 411893 411902 426043 430584 440876 451248 452813 457063 464445 464460 467003 468154 476186 479816 485129 486874 495396 499857 500941 502089 504336 504769 505673 508292 510898 516661 526894 529999 530700 531223 532655 532765 534387 534585 535830 537864 541575 545372 545430 545605 559178 566320 568189 573403 586662 591197 592917 593096 596929 599833 599865 600021 600200 600252 600257 600312 600360 600972 601578 631593 632650 633435 635975 638477 639751 639823 640771 641978 641996 644986 647344 647948 648241 685701 688546 697220 709871 714183 715283 718678 718746 720717 728145 728152 728200 730091 745938 747067 756413 756479 765349 765683 772107 781779 781924 784750 789954 791489 794228 799695 800338 800339 801949 803019 805935 806947 815299 818442 825864 ] |
||||||||||||||||||||||||||||||
|
15.70 ms (8.62%) |
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 532765 411893 534387 537864 599833 486874 718678 784750 791489 457063 600312 644986 500941 600021 635975 183044 451248 411344 715283 728152 411691 772107 794228 545605 545372 411902 818442 688546 530700 532655 648241 600360 263144 508292 718746 805935 409916 806947 825864 801949 756479 647948 599865 485129 781779 756413 401799 593096 697220 504336 541575 596929 815299 781924 728200 714183 382295 526894 586662 720717 800339 747067 632650 591197 476186 529999 745938 573403 685701 600252 600257 601578 531223 516661 566320 600200 639823 640771 502089 426043 370755 505673 510898 545430 440876 600972 535830 592917 638477 800338 789954 395583 799695 803019 765349 765683 709871 495396 430584 479816 559178 647344 633435 639751 641978 464460 467003 534585 452813 504769 468154 568189 728145 730091 400162 499857 641996 464445 631593 21981 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.28%) |
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 21981 183044 263144 370755 382295 395583 400162 401799 409916 411344 411691 411893 411902 426043 430584 440876 451248 452813 457063 464445 464460 467003 468154 476186 479816 485129 486874 495396 499857 500941 502089 504336 504769 505673 508292 510898 516661 526894 529999 530700 531223 532655 532765 534387 534585 535830 537864 541575 545372 545430 545605 559178 566320 568189 573403 586662 591197 592917 593096 596929 599833 599865 600021 600200 600252 600257 600312 600360 600972 601578 631593 632650 633435 635975 638477 639751 639823 640771 641978 641996 644986 647344 647948 648241 685701 688546 697220 709871 714183 715283 718678 718746 720717 728145 728152 728200 730091 745938 747067 756413 756479 765349 765683 772107 781779 781924 784750 789954 791489 794228 799695 800338 800339 801949 803019 805935 806947 815299 818442 825864 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature big squirt"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature большие сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature большие сквирт оргазм"
]
|
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.