Query Metrics
7
Database Queries
7
Different statements
411.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.53 ms (50.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"девушка лижет женщинам"
]
|
||||||||||||||||||||||||||||||
|
172.56 ms (41.94%) |
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 145335 152882 388862 396074 414306 420635 424749 425655 429409 430190 447032 448845 452387 456847 463837 464139 466561 472638 474302 476234 479780 479794 482606 486805 492364 493211 498882 505504 512722 523394 523491 523680 523778 524986 528038 534334 535835 541630 551209 555314 556656 559601 559874 561807 567110 573379 573470 576691 583314 591189 592532 594907 595835 599927 605308 606101 607079 607450 610138 632010 632031 636053 639739 643041 644373 650188 650313 650660 664960 667525 670951 675084 680611 686035 686044 687972 699599 720758 725353 728169 729200 729284 732258 736233 758492 759775 760809 764909 765841 767040 773799 779069 789659 789992 795024 795104 796193 796494 797801 799601 803173 803343 803541 804249 804763 806203 806530 806777 807687 810982 812259 813520 815212 815381 815524 815941 817724 817924 824208 825187 ] |
||||||||||||||||||||||||||||||
|
22.96 ms (5.58%) |
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 817924 815212 474302 479780 479794 486805 452387 493211 535835 523394 476234 559601 567110 573470 555314 687972 573379 591189 643041 632031 636053 592532 594907 606101 803343 806777 799601 765841 797801 813520 760809 764909 728169 773799 607079 810982 424749 498882 523491 388862 815524 807687 505504 595835 817724 686044 806530 650313 512722 675084 523778 145335 796193 789992 789659 804763 429409 466561 599927 639739 420635 664960 644373 425655 670951 632010 472638 556656 152882 804249 448845 524986 396074 447032 725353 736233 551209 610138 759775 767040 729284 758492 796494 464139 825187 824208 482606 559874 680611 720758 583314 607450 795024 795104 803173 803541 812259 729200 806203 815381 561807 699599 605308 779069 456847 523680 667525 541630 815941 686035 732258 430190 414306 492364 534334 528038 463837 576691 650188 650660 ] |
||||||||||||||||||||||||||||||
|
3.48 ms (0.85%) |
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 145335 152882 388862 396074 414306 420635 424749 425655 429409 430190 447032 448845 452387 456847 463837 464139 466561 472638 474302 476234 479780 479794 482606 486805 492364 493211 498882 505504 512722 523394 523491 523680 523778 524986 528038 534334 535835 541630 551209 555314 556656 559601 559874 561807 567110 573379 573470 576691 583314 591189 592532 594907 595835 599927 605308 606101 607079 607450 610138 632010 632031 636053 639739 643041 644373 650188 650313 650660 664960 667525 670951 675084 680611 686035 686044 687972 699599 720758 725353 728169 729200 729284 732258 736233 758492 759775 760809 764909 765841 767040 773799 779069 789659 789992 795024 795104 796193 796494 797801 799601 803173 803343 803541 804249 804763 806203 806530 806777 807687 810982 812259 813520 815212 815381 815524 815941 817724 817924 824208 825187 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (0.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк лиза женщин"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.42%) |
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.