Query Metrics
7
Database Queries
7
Different statements
188.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.40 ms (87.41%) |
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 382661 382931 392069 396816 397063 398724 441541 496245 521742 530175 530261 530595 540983 553470 578353 580109 580606 588110 592177 592867 616395 617854 630578 632938 638131 646076 655170 668034 674850 676156 680879 681456 696067 710432 711000 716637 720152 727442 727683 728761 728938 730479 730857 734327 734432 739016 739087 740974 741138 744613 745289 745923 747425 748108 748661 753034 756290 756403 757571 757804 761224 763357 764105 764515 764530 766140 766887 767291 768187 768803 770204 770375 772799 773402 778096 778122 778776 778930 779405 781186 782525 782962 783950 784171 784195 786702 788062 789899 790216 790865 791630 792015 792264 792702 793953 795002 796406 796765 798027 800800 801310 801677 802788 802856 806229 807932 810876 817988 818704 819644 819936 820536 821731 822571 822726 825055 825246 ] |
||||||||||||||||||||||||||||||
|
13.56 ms (7.21%) |
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 768803 768187 825246 739087 773537 818704 821731 822571 817988 530261 676156 681456 696067 680879 778930 789899 781186 792264 784171 784195 767291 770204 757571 744613 740974 772799 793953 382931 810876 727683 728761 764515 802788 496245 530595 578353 655170 588110 778776 728938 761224 773402 741138 756403 782525 397063 441541 720152 779405 807932 734432 764105 730479 711000 392069 382661 819644 820536 822726 819936 530175 580109 646076 674850 592177 616395 778122 786702 791630 795002 801677 796765 727442 788062 798027 801310 730857 734327 745289 747425 756290 770375 764530 745923 753034 766140 632938 782962 792702 398724 396816 668034 630578 716637 790216 790865 521742 553470 780457 778096 796406 802856 757804 766887 748661 762511 763357 617854 638131 783950 792015 806229 825055 540983 580606 710432 592867 800800 739016 748108 ] |
||||||||||||||||||||||||||||||
|
3.64 ms (1.94%) |
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 382661 382931 392069 396816 397063 398724 441541 496245 521742 530175 530261 530595 540983 553470 578353 580109 580606 588110 592177 592867 616395 617854 630578 632938 638131 646076 655170 668034 674850 676156 680879 681456 696067 710432 711000 716637 720152 727442 727683 728761 728938 730479 730857 734327 734432 739016 739087 740974 741138 744613 745289 745923 747425 748108 748661 753034 756290 756403 757571 757804 761224 763357 764105 764515 764530 766140 766887 767291 768187 768803 770204 770375 772799 773402 778096 778122 778776 778930 779405 781186 782525 782962 783950 784171 784195 786702 788062 789899 790216 790865 791630 792015 792264 792702 793953 795002 796406 796765 798027 800800 801310 801677 802788 802856 806229 807932 810876 817988 818704 819644 819936 820536 821731 822571 822726 825055 825246 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"little секс"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"little sex"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"little секс"
]
|
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.