Query Metrics
7
Database Queries
7
Different statements
427.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.60 ms (50.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен вебкамер"
]
|
||||||||||||||||||||||||||||||
|
191.52 ms (44.84%) |
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 8757 393798 397100 400589 536480 614930 615687 617127 650491 653752 691373 705064 709870 713021 715913 716375 718138 719554 725766 727552 727558 728199 728492 728880 728891 729278 730135 733513 734629 736755 738343 738763 740674 740734 741336 744223 744370 744812 744814 745357 746637 747065 748030 748826 748966 750607 752040 753980 758833 759178 760838 761253 762387 762974 763866 763902 764293 765042 765504 766243 766406 766416 766468 766476 767119 767803 768418 768702 768921 769387 771865 772859 773211 773349 773357 773717 773738 773753 775119 776679 777964 778193 778433 780369 782162 785562 786320 787266 787932 788437 789554 792218 792719 793556 794102 795109 795846 795850 796224 797277 797281 799921 800505 801566 801659 802901 803934 804545 805648 805658 810934 811144 811834 812250 812323 813120 813540 824958 ] |
||||||||||||||||||||||||||||||
|
11.84 ms (2.77%) |
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 812250 812323 813120 740734 744814 750607 761253 765042 765504 766476 767803 768702 769387 773349 773357 782162 787266 788437 789554 792218 792719 793556 795109 795846 795850 800505 801566 801659 805658 810934 811144 811834 728199 738763 744812 745357 748030 759178 760838 768418 773753 729278 736755 738343 744370 748826 752040 758833 764293 766468 767119 773211 725766 728492 728880 728891 730135 744223 746637 748966 762387 762974 773738 727552 727558 734629 740674 741336 747065 753980 763866 763902 766243 768921 771865 772859 773717 614930 615687 617127 713021 715913 719554 775119 776679 777964 778193 778433 778435 780369 785562 787932 794102 799921 802901 803934 813540 397100 400589 796224 650491 805648 393798 716375 718138 705064 691373 786320 797277 804545 766406 766416 733513 797281 8757 826522 824958 536480 653752 709870 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (0.69%) |
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 8757 393798 397100 400589 536480 614930 615687 617127 650491 653752 691373 705064 709870 713021 715913 716375 718138 719554 725766 727552 727558 728199 728492 728880 728891 729278 730135 733513 734629 736755 738343 738763 740674 740734 741336 744223 744370 744812 744814 745357 746637 747065 748030 748826 748966 750607 752040 753980 758833 759178 760838 761253 762387 762974 763866 763902 764293 765042 765504 766243 766406 766416 766468 766476 767119 767803 768418 768702 768921 769387 771865 772859 773211 773349 773357 773717 773738 773753 775119 776679 777964 778193 778433 780369 782162 785562 786320 787266 787932 788437 789554 792218 792719 793556 794102 795109 795846 795850 796224 797277 797281 799921 800505 801566 801659 802901 803934 804545 805648 805658 810934 811144 811834 812250 812323 813120 813540 824958 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife webcam"
]
|
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.