Query Metrics
7
Database Queries
7
Different statements
236.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.73 ms (89.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 392065 397001 398334 398683 398701 403035 418560 419461 419633 419816 421485 427911 428299 428305 432390 432467 433574 433696 433963 439852 443197 444814 445266 453850 456161 469741 471536 477385 482933 485016 485247 493820 493827 500320 505328 514960 517959 521082 523751 524839 526032 528062 531002 537774 538289 539235 543750 554827 556261 558324 558356 568303 573351 576444 581930 582836 583619 583859 584350 585882 592325 598503 598767 601211 621600 622875 628037 651724 652345 660317 660345 661583 680581 684874 684883 685758 701291 708570 708851 711133 722403 723825 731350 740749 744390 746355 751426 751712 752416 757188 758846 763156 764406 765097 765252 765402 767186 770747 777876 780284 780368 782744 785079 785123 785738 786317 786498 789785 792721 796397 797101 804293 806817 816624 816654 817199 817712 825273 827676 ] |
||||||||||||||||||||||||||||||
|
14.37 ms (6.08%) |
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 471536 444814 443197 524839 419461 419633 469741 558324 568303 598503 433696 433963 428299 428305 433574 456161 514960 517959 505328 523751 445266 418560 419816 432467 817712 825273 493820 521082 500320 528062 538289 537774 485016 543750 573351 581930 583859 582836 583619 651724 680581 684883 652345 661583 684874 708570 708851 660317 660345 722403 554827 598767 621600 622875 585882 592325 780284 785123 786317 786498 804293 780368 797101 752416 757188 758846 765097 765252 767186 782744 785079 785738 789785 796397 806817 746355 751426 770747 723825 744390 751712 764406 763156 770317 731350 740749 765402 701291 711133 777876 792721 453850 421485 392065 398334 398701 485247 576444 685758 628037 601211 439852 477385 482933 397001 398683 403035 432390 427911 816624 817199 816654 827676 493827 526032 531002 539235 558356 584350 556261 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.17%) |
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 392065 397001 398334 398683 398701 403035 418560 419461 419633 419816 421485 427911 428299 428305 432390 432467 433574 433696 433963 439852 443197 444814 445266 453850 456161 469741 471536 477385 482933 485016 485247 493820 493827 500320 505328 514960 517959 521082 523751 524839 526032 528062 531002 537774 538289 539235 543750 554827 556261 558324 558356 568303 573351 576444 581930 582836 583619 583859 584350 585882 592325 598503 598767 601211 621600 622875 628037 651724 652345 660317 660345 661583 680581 684874 684883 685758 701291 708570 708851 711133 722403 723825 731350 740749 744390 746355 751426 751712 752416 757188 758846 763156 764406 765097 765252 765402 767186 770747 777876 780284 780368 782744 785079 785123 785738 786317 786498 789785 792721 796397 797101 804293 806817 816624 816654 817199 817712 825273 827676 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen pussy webcam"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen pussy вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.72%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen 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.