Query Metrics
7
Database Queries
7
Different statements
163.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.61 ms (85.54%) |
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 76150 185428 249773 330564 338411 350287 386212 390990 398355 398399 398907 403782 415092 423436 432804 447733 449108 450190 452275 496247 505947 522055 531340 533383 534615 535993 539241 539283 541283 542106 546292 546434 546493 550345 550973 551588 552621 552730 559423 565215 574157 574211 604552 625757 625799 634540 653124 654337 654353 654398 656494 656619 659212 662146 664224 664968 676308 677191 680342 682918 691197 693425 695123 695915 705225 714392 717128 720579 720737 723637 740743 742144 743039 750129 750769 755576 756972 766883 769036 770506 770835 773640 776363 777109 777143 777754 778641 779195 779681 781077 781091 781154 783000 783673 787282 787433 789757 791770 794511 796073 797918 802043 803548 803748 804020 807472 807521 810338 811046 812149 814732 816613 817734 818085 819737 823490 825537 825557 826162 827984 ] |
||||||||||||||||||||||||||||||
|
13.54 ms (8.30%) |
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 770506 773640 714392 717128 776363 778641 779195 781077 781091 781154 783673 787433 803548 803748 804020 810338 811046 403782 423436 76150 185428 249773 823490 825537 816613 817734 826162 827984 447733 539241 496247 522055 539283 552730 565215 541283 552621 691197 693425 676308 654337 654398 664968 695915 720579 604552 625799 777109 783000 794511 777754 740743 789757 791770 797918 756972 769036 750129 770835 750769 625757 634540 777143 779681 812149 350287 695123 398907 574211 546493 659212 682918 546292 802043 807472 807521 787282 796073 742144 766883 743039 755576 390990 386212 338411 330564 398399 398355 432804 415092 818085 723637 819737 814732 825557 449108 450190 452275 533383 534615 535993 505947 531340 542106 546434 550973 551588 574157 550345 559423 656619 664224 677191 680342 705225 720737 653124 654353 656494 662146 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.73%) |
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 76150 185428 249773 330564 338411 350287 386212 390990 398355 398399 398907 403782 415092 423436 432804 447733 449108 450190 452275 496247 505947 522055 531340 533383 534615 535993 539241 539283 541283 542106 546292 546434 546493 550345 550973 551588 552621 552730 559423 565215 574157 574211 604552 625757 625799 634540 653124 654337 654353 654398 656494 656619 659212 662146 664224 664968 676308 677191 680342 682918 691197 693425 695123 695915 705225 714392 717128 720579 720737 723637 740743 742144 743039 750129 750769 755576 756972 766883 769036 770506 770835 773640 776363 777109 777143 777754 778641 779195 779681 781077 781091 781154 783000 783673 787282 787433 789757 791770 794511 796073 797918 802043 803548 803748 804020 807472 807521 810338 811046 812149 814732 816613 817734 818085 819737 823490 825537 825557 826162 827984 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"creampie girl"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"creampie девушк"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"creampie девушк"
]
|
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.