Query Metrics
7
Database Queries
7
Different statements
187.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.42 ms (89.76%) |
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 378600 534044 544034 720093 722955 724756 724985 725742 726749 727005 728983 729111 732653 733187 734255 734954 735589 736158 736739 736892 737388 739977 740865 744724 746174 747251 747638 747965 747997 751287 752082 752182 752396 755056 757369 757941 758412 758663 759774 760630 760949 761920 763186 764609 764695 765420 766187 766497 767487 767535 767620 767993 768081 768328 768343 768518 768750 769035 769619 770506 770571 771204 771561 771898 771908 772866 773390 773617 773640 773773 775325 775460 775654 776355 778064 778073 778938 779662 781142 781528 781590 782358 783372 783440 783716 784614 786332 787847 788643 788663 790586 790680 790904 791135 792321 792413 792972 793055 793989 795646 796309 796480 796660 796750 797232 797850 800431 800897 801207 801830 802077 803432 807556 810054 811346 813611 813680 814658 ] |
||||||||||||||||||||||||||||||
|
10.39 ms (5.54%) |
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 736739 758412 768328 770571 724756 735589 739977 744724 747251 752082 758663 771204 771309 726749 733187 747638 747997 751287 752182 757941 759774 763186 767535 767620 768518 768750 769035 771561 771898 773390 725742 737388 740865 770506 771908 772866 773640 773773 776355 778064 778073 778938 784614 786332 788663 792972 795646 800431 800897 736158 760630 544034 722955 775654 732653 752396 773617 792321 736892 768343 769619 729111 767993 787847 378600 534044 781590 814658 813611 813680 720093 775325 779662 781142 790586 790680 790904 791135 792413 793989 796309 796480 796750 801830 811346 775460 781528 782358 783440 783716 796660 797232 803432 734255 766497 768081 783372 788643 793055 797850 801207 802077 807556 810054 746174 747965 755056 761920 764695 727005 728983 734954 764609 766187 765420 767487 771135 724985 757369 760949 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.48%) |
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 378600 534044 544034 720093 722955 724756 724985 725742 726749 727005 728983 729111 732653 733187 734255 734954 735589 736158 736739 736892 737388 739977 740865 744724 746174 747251 747638 747965 747997 751287 752082 752182 752396 755056 757369 757941 758412 758663 759774 760630 760949 761920 763186 764609 764695 765420 766187 766497 767487 767535 767620 767993 768081 768328 768343 768518 768750 769035 769619 770506 770571 771204 771561 771898 771908 772866 773390 773617 773640 773773 775325 775460 775654 776355 778064 778073 778938 779662 781142 781528 781590 782358 783372 783440 783716 784614 786332 787847 788643 788663 790586 790680 790904 791135 792321 792413 792972 793055 793989 795646 796309 796480 796660 796750 797232 797850 800431 800897 801207 801830 802077 803432 807556 810054 811346 813611 813680 814658 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm homemade"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.23 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.