Query Metrics
7
Database Queries
7
Different statements
191.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.65 ms (83.97%) |
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 418385 444315 529680 542912 545833 548128 567801 567824 585161 629932 634713 682244 693679 717614 718341 718448 718451 724458 726169 726379 732113 732850 732965 734680 735947 736329 737491 738966 741937 742887 743841 746190 748608 749678 749681 750614 750767 751425 751526 751532 752738 755358 757440 757688 757713 762485 763727 763747 765361 765371 766007 767707 768820 769514 769725 769864 769985 770228 771804 771949 772040 772145 773101 773134 774205 775679 780308 782389 783309 786577 787981 789791 790151 790387 790824 791726 791966 794239 794256 795221 797345 799039 799090 799355 799912 800976 801339 801578 802318 803741 803839 804137 804262 805138 805362 807640 807866 807888 808323 809618 810649 812371 812383 812411 812493 812530 812947 813023 818186 819351 820328 824856 826614 826698 826703 827097 827184 827511 827668 827701 ] |
||||||||||||||||||||||||||||||
|
20.28 ms (10.60%) |
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 799355 804137 805138 810649 812383 812411 790387 799039 799090 801578 804262 805362 807866 808323 812371 812947 736329 757713 772145 773134 783309 787981 789791 790151 791966 794256 795221 803839 807888 812493 812530 726169 726379 732113 732965 737491 741937 750767 751526 752738 762485 768820 769985 771804 772040 732850 738966 748608 755358 765361 769725 769864 774205 724458 735947 742887 751532 757440 757688 765371 766007 767707 770228 771949 773101 734680 743841 746190 749678 749681 750614 763727 763747 769514 775679 780308 782389 786577 790824 791726 794239 799912 801339 807640 809618 813023 418385 444315 542912 548128 545833 585161 634713 800976 803741 797345 802318 751425 629932 820328 824856 826614 826703 826698 819351 827097 827184 827511 827701 818186 827668 529680 567801 567824 682244 718448 718451 693679 717614 718341 ] |
||||||||||||||||||||||||||||||
|
3.31 ms (1.73%) |
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 418385 444315 529680 542912 545833 548128 567801 567824 585161 629932 634713 682244 693679 717614 718341 718448 718451 724458 726169 726379 732113 732850 732965 734680 735947 736329 737491 738966 741937 742887 743841 746190 748608 749678 749681 750614 750767 751425 751526 751532 752738 755358 757440 757688 757713 762485 763727 763747 765361 765371 766007 767707 768820 769514 769725 769864 769985 770228 771804 771949 772040 772145 773101 773134 774205 775679 780308 782389 783309 786577 787981 789791 790151 790387 790824 791726 791966 794239 794256 795221 797345 799039 799090 799355 799912 800976 801339 801578 802318 803741 803839 804137 804262 805138 805362 807640 807866 807888 808323 809618 810649 812371 812383 812411 812493 812530 812947 813023 818186 819351 820328 824856 826614 826698 826703 827097 827184 827511 827668 827701 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tiktok boobs"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"тикток социальн сет boobs"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"тикток социальн сет boobs"
]
|
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.