Query Metrics
7
Database Queries
7
Different statements
147.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.80 ms (86.40%) |
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 385222 414082 425472 433594 445497 445511 447550 464043 465167 471628 491015 509949 511514 518054 524397 527066 533469 544422 551816 552287 554253 554718 557574 560879 561158 561169 563873 565631 566005 568877 574937 575272 581622 588842 590076 590095 590174 591676 592432 602742 610804 610828 611448 612520 613942 613983 614821 620856 623619 624494 630744 646135 667151 674068 674743 678238 682210 685384 689492 692566 692818 697853 699166 709320 709393 718050 720868 725585 728192 728702 729711 734610 735094 737126 742370 745256 755779 756920 757914 760513 761609 763474 764121 765881 767327 768801 775454 777471 779162 779330 779890 781353 781631 784477 785542 786925 787417 787965 788080 788933 789549 789913 790208 791531 791821 791838 792483 793329 794432 796576 797103 800564 803159 804896 805700 807273 810919 813572 823632 827883 ] |
||||||||||||||||||||||||||||||
|
10.71 ms (7.24%) |
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 823632 827883 445497 491015 509949 533469 552287 574937 566005 674068 709320 674743 718050 614821 613942 592432 777471 779890 785542 779162 781631 788933 792483 729711 745256 756920 787417 791838 804896 805700 765881 728192 757914 763474 737126 761609 611448 775454 788080 791531 447550 602742 623619 527066 464043 518054 590174 610828 465167 560879 581622 590076 425472 554253 551816 565631 591676 511514 471628 767327 414082 554718 561158 685384 689492 697853 699166 646135 692818 590095 612520 789913 794432 796576 764121 787965 803159 755779 725585 728702 734610 742370 760513 433594 813572 768801 692566 620856 613983 781353 797103 575272 524397 385222 544422 568877 678238 720868 709393 557574 610804 624494 789549 793329 790208 800564 807273 810919 735094 445511 563873 561169 667151 682210 588842 630744 779330 786925 791821 784477 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.74%) |
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 385222 414082 425472 433594 445497 445511 447550 464043 465167 471628 491015 509949 511514 518054 524397 527066 533469 544422 551816 552287 554253 554718 557574 560879 561158 561169 563873 565631 566005 568877 574937 575272 581622 588842 590076 590095 590174 591676 592432 602742 610804 610828 611448 612520 613942 613983 614821 620856 623619 624494 630744 646135 667151 674068 674743 678238 682210 685384 689492 692566 692818 697853 699166 709320 709393 718050 720868 725585 728192 728702 729711 734610 735094 737126 742370 745256 755779 756920 757914 760513 761609 763474 764121 765881 767327 768801 775454 777471 779162 779330 779890 781353 781631 784477 785542 786925 787417 787965 788080 788933 789549 789913 790208 791531 791821 791838 792483 793329 794432 796576 797103 800564 803159 804896 805700 807273 810919 813572 823632 827883 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step sex sister"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step секс sister"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step секс sister"
]
|
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.