Query Metrics
7
Database Queries
7
Different statements
364.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.84 ms (57.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"onlyfans teen"
]
|
||||||||||||||||||||||||||||||
|
131.07 ms (35.92%) |
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 452228 452279 470375 540917 541525 562424 572683 579677 579827 583276 587588 610804 626930 629166 632573 634021 650727 655238 661894 665831 674220 677624 684492 693636 699987 703277 706754 707855 714672 725018 726869 733445 735260 740287 740384 740502 740534 744153 746094 747677 749202 753972 755588 755727 755749 756298 761706 762043 762746 762908 762914 762965 764220 765406 765456 765724 766076 766622 766893 767008 767071 767102 767602 769066 770274 770456 771349 771452 772583 774684 774689 775537 775704 775716 775717 775720 777134 778032 778078 778294 778361 779001 779002 779653 779685 779779 780820 781607 782531 782808 783074 783576 786793 786899 787808 787868 788596 789871 790399 791231 791283 791365 792468 793283 794365 799710 799830 800498 801557 805172 806590 809072 810512 811676 812838 813116 813285 813369 818938 826285 ] |
||||||||||||||||||||||||||||||
|
15.75 ms (4.32%) |
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 610804 632573 634021 587588 626930 629166 774684 775537 778078 778361 779001 779685 779779 781607 782808 783576 786793 786899 787868 790399 791231 791365 793283 794365 799710 799830 805172 810512 813116 813285 813369 774689 775717 775720 778032 778294 779653 780820 791283 800498 811676 740534 749202 753972 755588 755749 761706 762746 762965 764220 770274 771349 771452 788596 792468 801557 809072 812838 725018 762908 762914 765456 766076 767602 769066 726869 740287 740384 740502 755727 756298 762043 766622 767071 767102 770456 772583 733445 746094 747677 765406 765724 766893 735260 744153 767008 699987 703277 706754 714672 775704 775716 777134 779002 782531 783074 787808 789871 806590 452228 452279 470375 579677 572683 818938 826285 540917 579827 541525 562424 583276 650727 655238 674220 677624 684492 707855 661894 665831 693636 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (0.78%) |
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 452228 452279 470375 540917 541525 562424 572683 579677 579827 583276 587588 610804 626930 629166 632573 634021 650727 655238 661894 665831 674220 677624 684492 693636 699987 703277 706754 707855 714672 725018 726869 733445 735260 740287 740384 740502 740534 744153 746094 747677 749202 753972 755588 755727 755749 756298 761706 762043 762746 762908 762914 762965 764220 765406 765456 765724 766076 766622 766893 767008 767071 767102 767602 769066 770274 770456 771349 771452 772583 774684 774689 775537 775704 775716 775717 775720 777134 778032 778078 778294 778361 779001 779002 779653 779685 779779 780820 781607 782531 782808 783074 783576 786793 786899 787808 787868 788596 789871 790399 791231 791283 791365 792468 793283 794365 799710 799830 800498 801557 805172 806590 809072 810512 811676 812838 813116 813285 813369 818938 826285 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (0.57%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"онлифанс социальн сет teen"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"онлифанс социальн сет teen"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.43%) |
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.