Query Metrics
7
Database Queries
7
Different statements
170.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.90 ms (84.04%) |
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 414979 416039 425003 433140 441447 442967 446197 446453 447780 449122 449208 449855 450426 451380 452180 453732 455006 455153 455447 456072 456925 457630 457680 461603 462844 462991 463000 463614 463623 464043 464694 471761 473586 475134 478818 483039 484144 484300 484499 486960 488496 488776 489281 490370 495002 496764 496980 497313 497951 499771 500268 500622 502453 502598 504739 504776 504906 509513 511413 511514 511602 511650 511804 514357 514624 514781 514829 516786 516876 518231 519510 519528 519661 520310 521537 522121 522663 525259 527444 527802 528116 528766 528914 528916 529171 531278 540968 545667 547557 553648 559747 561162 561346 563553 564122 565093 565138 565399 567716 569268 571333 580135 581712 584716 599326 599531 599752 601364 601879 601886 609861 613204 613924 615429 616747 618743 621454 621735 623619 624390 ] |
||||||||||||||||||||||||||||||
|
17.84 ms (10.49%) |
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 464694 452180 446453 463623 499771 511602 511650 527444 511413 511804 528916 488496 488776 519661 484300 514624 514781 514829 516876 519510 414979 484144 621454 446197 449855 462844 565138 609861 601879 624390 450426 461603 464043 456072 569268 599752 623619 599531 449122 425003 442967 449208 518231 528914 490370 504906 521537 483039 484499 527802 497951 441447 455447 457680 451380 453732 495002 584716 601364 475134 433140 447780 455153 463000 504739 540968 529171 497313 486960 511514 514357 580135 571333 599326 564122 559747 581712 416039 496980 471761 520310 456925 565093 567716 547557 462991 516786 509513 522121 601886 618743 531278 502598 502453 553648 478818 457630 473586 525259 496764 500268 561162 519528 528116 522663 455006 613204 563553 616747 463614 504776 489281 500622 561346 528766 613924 545667 615429 565399 621735 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful sister amateur"
]
|
||||||||||||||||||||||||||||||
|
2.19 ms (1.29%) |
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 414979 416039 425003 433140 441447 442967 446197 446453 447780 449122 449208 449855 450426 451380 452180 453732 455006 455153 455447 456072 456925 457630 457680 461603 462844 462991 463000 463614 463623 464043 464694 471761 473586 475134 478818 483039 484144 484300 484499 486960 488496 488776 489281 490370 495002 496764 496980 497313 497951 499771 500268 500622 502453 502598 504739 504776 504906 509513 511413 511514 511602 511650 511804 514357 514624 514781 514829 516786 516876 518231 519510 519528 519661 520310 521537 522121 522663 525259 527444 527802 528116 528766 528914 528916 529171 531278 540968 545667 547557 553648 559747 561162 561346 563553 564122 565093 565138 565399 567716 569268 571333 580135 581712 584716 599326 599531 599752 601364 601879 601886 609861 613204 613924 615429 616747 618743 621454 621735 623619 624390 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая sister любительск"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая sister любительск"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.