Query Metrics
7
Database Queries
7
Different statements
141.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.74 ms (83.78%) |
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 381809 396237 399905 416295 424087 425751 443668 460485 506312 514346 535804 536268 541547 544795 546575 547635 548900 570262 612476 622707 625401 631136 638145 652665 658553 659065 661599 662074 668987 670003 678238 682644 686848 687386 688999 699899 701509 704977 708701 716172 723123 724295 724442 727549 728646 730003 730607 731393 733130 734294 737106 739626 741952 746137 747565 756269 756343 758197 760407 763068 763579 763932 764028 765917 768380 768896 768909 769088 769587 771159 771445 771755 772404 772844 778860 778959 779203 779228 779383 779895 780310 781405 781569 783612 783823 783840 785056 785191 786421 788596 788914 789808 790480 790681 792203 793173 793462 794499 796214 796875 796955 797650 798521 800628 801129 802167 802976 803497 805621 805846 806865 807685 808217 814307 814993 821132 823655 825667 826307 826371 ] |
||||||||||||||||||||||||||||||
|
11.92 ms (8.41%) |
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 802976 460485 514346 506312 779895 771159 788596 814307 536268 652665 658553 662074 779228 805621 793462 801129 734294 763579 638145 778959 786421 396237 814993 541547 701509 704977 723123 800628 778860 785191 802167 739626 741952 747565 768896 790480 803497 416295 424087 399905 381809 443668 826307 823655 826371 535804 546575 548900 668987 670003 686848 661599 678238 682644 547635 612476 788914 793173 790681 807685 730003 764028 769088 772404 772844 781569 789808 796214 730607 756343 760407 746137 763932 728646 763068 765917 768380 768909 771755 727549 622707 779383 797650 425751 821132 825667 544795 570262 659065 699899 687386 708701 688999 716172 625401 631136 783612 783823 796955 798521 792203 737106 781405 783840 785056 796875 805846 808217 724442 756269 724295 733130 758197 769587 771445 731393 779203 780310 794499 806865 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (2.03%) |
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 381809 396237 399905 416295 424087 425751 443668 460485 506312 514346 535804 536268 541547 544795 546575 547635 548900 570262 612476 622707 625401 631136 638145 652665 658553 659065 661599 662074 668987 670003 678238 682644 686848 687386 688999 699899 701509 704977 708701 716172 723123 724295 724442 727549 728646 730003 730607 731393 733130 734294 737106 739626 741952 746137 747565 756269 756343 758197 760407 763068 763579 763932 764028 765917 768380 768896 768909 769088 769587 771159 771445 771755 772404 772844 778860 778959 779203 779228 779383 779895 780310 781405 781569 783612 783823 783840 785056 785191 786421 788596 788914 789808 790480 790681 792203 793173 793462 794499 796214 796875 796955 797650 798521 800628 801129 802167 802976 803497 805621 805846 806865 807685 808217 814307 814993 821132 823655 825667 826307 826371 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"face sex"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"face секс"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.39%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.37%) |
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.