Query Metrics
7
Database Queries
7
Different statements
457.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
218.57 ms (47.78%) |
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 495803 525041 536949 540669 548985 548988 552385 557607 561214 562020 571437 581289 583105 586209 588503 597180 597829 601727 612947 618226 620999 622964 628510 630140 633360 634700 639480 645798 648017 653031 657118 678214 683346 686916 689387 689399 692677 695693 700230 713136 721228 723482 724691 725304 727005 728661 731153 745836 758710 760263 760302 763524 765085 767312 767781 768072 768464 768518 768809 769360 770777 771684 771685 772010 772492 772823 772826 777690 777798 777928 778073 778753 779799 780405 781338 782352 783730 784436 785265 785959 786392 786659 786821 787340 788355 789793 790649 791188 791767 791904 792362 792527 792972 793055 793658 793759 793989 794053 795572 796303 796998 798142 798497 800843 801105 802940 803272 803674 803890 805270 806252 810552 811433 812456 813297 ] |
||||||||||||||||||||||||||||||
|
211.99 ms (46.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов cum"
]
|
||||||||||||||||||||||||||||||
|
18.81 ms (4.11%) |
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 495803 536949 540669 525041 548988 552385 571437 548985 557607 561214 562020 583105 653031 686916 692677 678214 683346 689399 695693 700230 645798 648017 657118 689387 581289 622964 633360 634700 612947 588503 586209 597180 597829 620999 628510 639480 778252 778753 780405 782352 784436 786659 793989 798497 813297 777690 777798 777928 779799 783730 786392 787340 790649 791188 791904 792362 793658 794053 796998 800843 802940 806252 810552 811433 812456 728661 767312 770777 772492 772826 781338 785265 785959 791767 793055 798142 801105 803674 725304 760263 763487 765085 768464 768809 769360 724691 727005 758710 760302 765378 771684 745836 763524 767781 768072 768442 768518 771135 772010 731153 771685 772823 601727 618226 630140 713136 721228 723482 778073 786821 788355 789793 792527 792972 793759 795572 796303 803272 803890 805270 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (0.66%) |
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 495803 525041 536949 540669 548985 548988 552385 557607 561214 562020 571437 581289 583105 586209 588503 597180 597829 601727 612947 618226 620999 622964 628510 630140 633360 634700 639480 645798 648017 653031 657118 678214 683346 686916 689387 689399 692677 695693 700230 713136 721228 723482 724691 725304 727005 728661 731153 745836 758710 760263 760302 763524 765085 767312 767781 768072 768464 768518 768809 769360 770777 771684 771685 772010 772492 772823 772826 777690 777798 777928 778073 778753 779799 780405 781338 782352 783730 784436 785265 785959 786392 786659 786821 787340 788355 789793 790649 791188 791767 791904 792362 792527 792972 793055 793658 793759 793989 794053 795572 796303 796998 798142 798497 800843 801105 802940 803272 803674 803890 805270 806252 810552 811433 812456 813297 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov cum"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов cum"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.35%) |
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.