Query Metrics
7
Database Queries
7
Different statements
403.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.96 ms (51.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fat секс"
]
|
||||||||||||||||||||||||||||||
|
171.53 ms (42.47%) |
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 110884 111339 111630 122767 321414 385596 387656 387908 391923 393600 393621 395983 417821 444453 452335 453665 485945 486060 493770 507081 514755 524787 539337 544795 583151 585256 585364 589277 603072 609702 623516 654240 662171 662898 664529 665447 666831 667296 667906 674108 680745 683012 696983 707044 710686 710856 710858 714950 715543 715802 716218 717432 721148 721373 723993 726063 726229 726962 727459 731007 734560 734626 735435 737076 742274 742651 743118 744227 744384 744418 745037 745535 749473 749605 749620 755414 755989 756237 756253 757031 758801 759744 761132 761397 765672 768756 770331 772119 772359 772602 781932 786527 791502 794153 794178 795984 796576 799367 800225 800520 802950 803932 804688 805341 805747 805867 805902 805908 811248 813485 814962 815583 817255 818967 820804 824342 824568 824848 825444 827926 ] |
||||||||||||||||||||||||||||||
|
13.35 ms (3.31%) |
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 710858 791502 737076 756253 765672 735435 817255 667296 707044 714950 674108 589277 781932 726962 749473 755414 772359 742651 770331 803932 393600 825444 539337 665447 666831 710686 664529 710856 609702 623516 794153 804688 805341 731007 761397 772119 795984 802950 805747 811248 734560 723993 745535 726063 800225 453665 391923 111630 387908 824342 122767 814962 768756 744384 818967 805908 758801 111339 827926 452335 524787 717432 721373 715543 603072 786527 756237 727459 749605 110884 824568 824848 486060 544795 654240 680745 696983 683012 585364 805867 799367 805902 734626 744418 755989 745037 744227 749620 715802 393621 507081 385596 387656 493770 514755 667906 662898 662171 716218 721148 583151 585256 794178 796576 800520 813485 761132 726229 757031 743118 759744 772602 742274 444453 485945 395983 321414 417821 820804 815583 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (0.79%) |
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 110884 111339 111630 122767 321414 385596 387656 387908 391923 393600 393621 395983 417821 444453 452335 453665 485945 486060 493770 507081 514755 524787 539337 544795 583151 585256 585364 589277 603072 609702 623516 654240 662171 662898 664529 665447 666831 667296 667906 674108 680745 683012 696983 707044 710686 710856 710858 714950 715543 715802 716218 717432 721148 721373 723993 726063 726229 726962 727459 731007 734560 734626 735435 737076 742274 742651 743118 744227 744384 744418 745037 745535 749473 749605 749620 755414 755989 756237 756253 757031 758801 759744 761132 761397 765672 768756 770331 772119 772359 772602 781932 786527 791502 794153 794178 795984 796576 799367 800225 800520 802950 803932 804688 805341 805747 805867 805902 805908 811248 813485 814962 815583 817255 818967 820804 824342 824568 824848 825444 827926 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fat fuck"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fat секс"
]
|
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.