Query Metrics
7
Database Queries
7
Different statements
209.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
184.29 ms (87.81%) |
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 382884 393713 398201 399223 400490 403276 413268 417461 420600 421435 425481 427126 434208 435468 444579 446456 447195 454250 456341 456966 457169 459558 459751 460723 461098 462306 463161 463169 463225 469921 472912 473913 473924 474626 475453 484464 492794 500173 501139 503928 503955 507154 509473 514147 514789 515136 515202 523903 534771 540767 542934 545381 545914 553197 558052 564066 564132 564172 565912 572176 577502 586015 591441 591856 594863 599791 600553 601853 605856 607735 610952 612035 622035 623892 624014 624664 624827 626742 645965 656575 657777 671670 682912 687604 690797 691838 695316 695831 701682 709428 714461 721579 721999 726892 728166 744753 748541 759647 760938 789837 790867 790972 790977 791704 800316 800535 800563 805504 806378 811340 813660 814265 818936 819510 821628 821844 821846 821849 821867 825561 ] |
||||||||||||||||||||||||||||||
|
15.36 ms (7.32%) |
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 591441 558052 714461 671670 813660 821628 645965 626742 790977 789837 403276 501139 622035 503928 421435 446456 447195 460723 500173 514147 514789 545381 701682 607735 624014 800563 744753 721999 473924 463161 459751 393713 435468 454250 472912 656575 564172 427126 474626 469921 473913 400490 492794 503955 601853 821849 821846 821867 507154 553197 687604 599791 591856 811340 726892 417461 444579 515136 399223 509473 690797 610952 413268 534771 545914 577502 542934 572176 564066 564132 624664 425481 459558 463169 382884 819510 484464 691838 624827 612035 790972 759647 728166 565912 623892 594863 748541 457169 398201 434208 818936 821844 825561 456341 463225 456966 540767 695831 709428 721579 682912 695316 586015 600553 605856 791704 800535 805504 760938 790867 800316 806378 462306 461098 475453 420600 515202 523903 657777 814265 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.33%) |
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 382884 393713 398201 399223 400490 403276 413268 417461 420600 421435 425481 427126 434208 435468 444579 446456 447195 454250 456341 456966 457169 459558 459751 460723 461098 462306 463161 463169 463225 469921 472912 473913 473924 474626 475453 484464 492794 500173 501139 503928 503955 507154 509473 514147 514789 515136 515202 523903 534771 540767 542934 545381 545914 553197 558052 564066 564132 564172 565912 572176 577502 586015 591441 591856 594863 599791 600553 601853 605856 607735 610952 612035 622035 623892 624014 624664 624827 626742 645965 656575 657777 671670 682912 687604 690797 691838 695316 695831 701682 709428 714461 721579 721999 726892 728166 744753 748541 759647 760938 789837 790867 790972 790977 791704 800316 800535 800563 805504 806378 811340 813660 814265 818936 819510 821628 821844 821846 821849 821867 825561 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young девушк любительск"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young girl amateur"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young девушк любительск"
]
|
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.