Query Metrics
7
Database Queries
7
Different statements
212.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
192.08 ms (90.59%) |
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 358259 381809 390645 399905 407171 416295 424087 425751 426741 443668 458360 465494 483194 487320 495123 509521 527214 535804 544795 546575 547635 548900 554741 560265 563678 570262 606332 612476 618778 622707 625401 631136 659065 661599 667169 668987 670003 678238 682644 686848 687386 688416 688999 699899 708701 716172 720674 724295 724442 727549 728646 728756 730003 730607 731393 733130 737106 739626 741952 746137 747565 756269 756343 758197 760407 763068 763932 764028 765757 765917 768380 768896 768909 769088 769354 769587 771445 771755 772404 772844 778860 779120 779203 779383 780310 781405 781569 783612 783823 783840 785056 785191 788914 789808 790480 790681 792203 793173 794499 796875 796955 797650 798521 802167 803497 805846 806865 807685 808217 812983 816604 821132 823655 824190 825161 825667 826025 826307 826371 826725 ] |
||||||||||||||||||||||||||||||
|
9.03 ms (4.26%) |
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 778860 785191 802167 739626 741952 728756 747565 765757 768896 790480 803497 416295 424087 399905 381809 443668 826307 823655 826371 535804 554741 546575 548900 668987 670003 686848 661599 678238 682644 547635 612476 788914 793173 790681 807685 730003 764028 769088 772404 772844 781569 789808 730607 756343 760407 746137 763932 728646 763068 765917 768380 768909 771755 727549 618778 622707 779383 797650 425751 821132 825667 487320 544795 570262 659065 699899 687386 708701 688999 716172 720674 625401 631136 783612 783823 796955 798521 779120 792203 737106 769354 781405 783840 785056 796875 805846 808217 724442 756269 724295 733130 758197 769587 771445 731393 606332 779203 780310 794499 806865 812983 390645 358259 407171 458360 426741 509521 495123 483194 826725 824190 826025 816604 825161 465494 527214 560265 563678 667169 688416 ] |
||||||||||||||||||||||||||||||
|
3.83 ms (1.81%) |
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 358259 381809 390645 399905 407171 416295 424087 425751 426741 443668 458360 465494 483194 487320 495123 509521 527214 535804 544795 546575 547635 548900 554741 560265 563678 570262 606332 612476 618778 622707 625401 631136 659065 661599 667169 668987 670003 678238 682644 686848 687386 688416 688999 699899 708701 716172 720674 724295 724442 727549 728646 728756 730003 730607 731393 733130 737106 739626 741952 746137 747565 756269 756343 758197 760407 763068 763932 764028 765757 765917 768380 768896 768909 769088 769354 769587 771445 771755 772404 772844 778860 779120 779203 779383 780310 781405 781569 783612 783823 783840 785056 785191 788914 789808 790480 790681 792203 793173 794499 796875 796955 797650 798521 802167 803497 805846 806865 807685 808217 812983 816604 821132 823655 824190 825161 825667 826025 826307 826371 826725 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс face"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex face"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс face"
]
|
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.