Query Metrics
7
Database Queries
7
Different statements
395.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.88 ms (53.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian blowjob webcam"
]
|
||||||||||||||||||||||||||||||
|
159.82 ms (40.38%) |
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 384181 391819 402278 406890 411339 418297 419225 421940 423333 423968 424146 427121 427455 429427 434428 434452 435667 437779 438536 438539 438540 441915 442584 443850 444131 444212 444670 445808 446560 447234 450383 452644 454768 460776 462143 462312 464954 469216 471550 474330 477638 477667 477739 477963 479127 479662 482832 483253 485954 487309 488514 488961 494573 498867 504167 504716 511042 546560 578301 584424 600098 600125 639156 646385 649316 673908 722165 722992 723004 731168 733059 733958 734858 735307 740005 742411 743575 745070 751961 754943 755046 761812 766426 768422 774713 774723 777898 778740 779735 780245 781621 781652 782030 782882 783318 787116 787161 789280 789763 790947 790948 791249 791397 791826 792739 793315 795637 799684 806862 814089 816809 819777 819785 825391 825881 826373 826688 826929 826932 ] |
||||||||||||||||||||||||||||||
|
14.41 ms (3.64%) |
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 814089 806862 745070 474330 429427 482832 421940 419225 498867 723004 774723 789280 793315 778740 780245 782882 789763 733958 791397 734858 777898 783318 445808 460776 504716 469216 384181 477638 600125 438536 411339 427121 438539 826373 826688 546560 649316 722165 646385 774713 787116 790948 790947 791249 792739 799684 761812 791826 751961 754943 755046 740005 762910 768422 743575 722992 779735 787161 795637 782030 488961 444212 450383 639156 444670 816809 819785 733059 454768 444131 462312 442584 781621 488514 584424 477667 479662 731168 427455 423968 462143 437779 418297 781652 402278 446560 819777 504167 434428 673908 438540 447234 471550 423333 494573 487309 578301 742411 477963 464954 485954 477739 735307 452644 600098 424146 443850 434452 441915 391819 479127 435667 406890 483253 511042 825391 825881 826929 826932 766426 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (0.77%) |
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 384181 391819 402278 406890 411339 418297 419225 421940 423333 423968 424146 427121 427455 429427 434428 434452 435667 437779 438536 438539 438540 441915 442584 443850 444131 444212 444670 445808 446560 447234 450383 452644 454768 460776 462143 462312 464954 469216 471550 474330 477638 477667 477739 477963 479127 479662 482832 483253 485954 487309 488514 488961 494573 498867 504167 504716 511042 546560 578301 584424 600098 600125 639156 646385 649316 673908 722165 722992 723004 731168 733059 733958 734858 735307 740005 742411 743575 745070 751961 754943 755046 761812 766426 768422 774713 774723 777898 778740 779735 780245 781621 781652 782030 782882 783318 787116 787161 789280 789763 790947 790948 791249 791397 791826 792739 793315 795637 799684 806862 814089 816809 819777 819785 825391 825881 826373 826688 826929 826932 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.55%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск минет оральн секс вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.43%) |
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.