Query Metrics
7
Database Queries
7
Different statements
149.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.16 ms (82.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 40835 117905 218669 382359 384158 384769 385577 386166 386896 390746 398715 399077 399146 400956 401482 403067 403134 404809 415300 415542 416018 416537 416704 417486 445738 451609 456048 476178 482769 493808 506371 508904 514880 515569 519095 519971 530021 531129 531131 531822 531850 531856 532732 534530 534542 541326 542142 544407 547480 548451 550904 550916 574138 574372 575589 580182 597167 597243 610029 615658 617807 618283 632645 632691 633474 633533 634106 639732 646239 647891 650139 650344 658785 660415 661900 662061 663234 672938 674943 677724 678153 678514 678529 678707 695559 698102 704641 713501 713507 713508 724109 735260 736307 738476 738826 741944 745083 750668 751670 753696 775184 775477 782792 782808 784242 794244 796270 799789 801925 804137 806346 808235 811365 814473 820682 824441 827830 827926 827928 827976 ] |
||||||||||||||||||||||||||||||
|
17.05 ms (11.43%) |
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 384769 445738 519095 633533 401482 531131 646239 390746 531129 678529 575589 580182 547480 678153 827928 827830 677724 741944 541326 674943 597243 698102 775477 403067 417486 519971 404809 632645 386166 456048 574372 678707 610029 416704 398715 399077 416537 415300 416018 482769 476178 534530 514880 530021 532732 534542 542142 695559 650139 660415 713508 634106 597167 808235 782792 738826 751670 750668 775184 382359 820682 647891 615658 784242 451609 386896 639732 806346 678514 632691 385577 531850 724109 736307 738476 384158 117905 40835 814473 824441 827976 827926 515569 550904 661900 650344 658785 782808 753696 735260 617807 796270 399146 218669 493808 531822 531856 550916 662061 672938 713501 713507 745083 508904 506371 548451 574138 544407 704641 663234 804137 794244 799789 618283 801925 811365 403134 633474 415542 400956 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.92%) |
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 40835 117905 218669 382359 384158 384769 385577 386166 386896 390746 398715 399077 399146 400956 401482 403067 403134 404809 415300 415542 416018 416537 416704 417486 445738 451609 456048 476178 482769 493808 506371 508904 514880 515569 519095 519971 530021 531129 531131 531822 531850 531856 532732 534530 534542 541326 542142 544407 547480 548451 550904 550916 574138 574372 575589 580182 597167 597243 610029 615658 617807 618283 632645 632691 633474 633533 634106 639732 646239 647891 650139 650344 658785 660415 661900 662061 663234 672938 674943 677724 678153 678514 678529 678707 695559 698102 704641 713501 713507 713508 724109 735260 736307 738476 738826 741944 745083 750668 751670 753696 775184 775477 782792 782808 784242 794244 796270 799789 801925 804137 806346 808235 811365 814473 820682 824441 827830 827926 827928 827976 ] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"extreme ass sex"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор жоп секс"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.89%) |
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.