Query Metrics
7
Database Queries
7
Different statements
184.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.60 ms (89.36%) |
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 400885 484245 539376 545869 567974 618640 619320 625841 629069 634331 640116 643214 644491 658818 665067 667097 700092 704410 709125 711231 717299 717502 722999 724770 724813 725429 729015 729047 729219 730181 733183 734351 735003 737352 737864 737884 739107 740137 740179 740184 740200 740963 741155 741865 743815 744177 746367 747628 748082 748087 748380 749004 749653 751395 751443 753755 756268 757940 762887 763910 764755 765955 767824 768731 774032 775562 778168 778330 780250 780658 782315 782765 787671 787739 790103 790295 793052 794407 795473 811809 817421 817771 819888 820008 820028 820742 823768 824047 824127 824159 824211 824602 824616 824693 824966 825165 825171 825334 825434 825459 825944 826169 826443 826553 826596 826724 826769 827083 827113 827174 827568 828120 828180 828364 828701 828741 ] |
||||||||||||||||||||||||||||||
|
9.89 ms (5.37%) |
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 737352 737864 743815 757940 767824 774032 787739 790103 793052 795473 811809 724770 729015 730181 737884 740137 740179 740200 748082 756268 724813 733183 735003 739107 763910 764755 741865 744177 747628 748087 753755 762887 765955 768731 729219 740184 746367 748380 751395 751443 618640 619320 625841 634331 640116 644491 700092 704410 709125 711231 717299 775562 778168 400885 824127 824211 824821 826553 826596 826724 817421 820008 820028 820742 824693 825165 825171 825459 826443 826769 827083 827113 827174 827568 817771 823768 824047 824159 824602 824616 824966 825334 825944 826340 826420 819888 826169 828180 828120 828741 828364 825434 828701 484245 539376 567974 545869 658818 665067 667097 717502 722999 629069 643214 778330 780250 780658 782315 782765 787671 794407 790295 725429 729047 734351 740963 741155 749004 749653 761714 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.56%) |
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 400885 484245 539376 545869 567974 618640 619320 625841 629069 634331 640116 643214 644491 658818 665067 667097 700092 704410 709125 711231 717299 717502 722999 724770 724813 725429 729015 729047 729219 730181 733183 734351 735003 737352 737864 737884 739107 740137 740179 740184 740200 740963 741155 741865 743815 744177 746367 747628 748082 748087 748380 749004 749653 751395 751443 753755 756268 757940 762887 763910 764755 765955 767824 768731 774032 775562 778168 778330 780250 780658 782315 782765 787671 787739 790103 790295 793052 794407 795473 811809 817421 817771 819888 820008 820028 820742 823768 824047 824127 824159 824211 824602 824616 824693 824966 825165 825171 825334 825434 825459 825944 826169 826443 826553 826596 826724 826769 827083 827113 827174 827568 828120 828180 828364 828701 828741 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur webcams"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск webcams"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск webcams"
]
|
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.