Query Metrics
7
Database Queries
7
Different statements
223.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
200.67 ms (89.89%) |
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 73421 181804 187353 193299 237950 238244 382006 383656 386017 386627 388791 390927 402346 403418 404036 405221 409076 409224 420163 421569 423513 426104 428616 429527 431719 433039 457358 460251 461418 463728 465926 469171 469173 477137 479893 483658 486738 492003 494247 495957 499261 508694 509544 515855 517697 528572 533057 538565 543792 544525 553248 554053 555983 555990 560052 564197 565684 571855 571997 574768 582997 586404 592475 592914 595946 596033 596752 598388 603181 609644 624391 636578 642622 644510 650038 664559 675055 675692 683404 689061 699444 705136 705144 709646 725130 731660 740497 742714 744226 750914 756458 757074 758573 759882 759927 764203 770226 774215 775858 780278 780311 785967 786384 786842 789278 790076 792012 798743 801081 801094 802220 805986 807255 807902 812265 813767 815074 818795 820383 826317 ] |
||||||||||||||||||||||||||||||
|
12.10 ms (5.42%) |
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 744226 740497 675055 386017 789278 426104 403418 528572 388791 494247 683404 586404 780311 725130 807255 756458 479893 421569 390927 598388 431719 469171 709646 515855 813767 560052 689061 705136 596033 785967 731660 757074 759882 609644 792012 463728 554053 582997 538565 802220 465926 386627 193299 187353 499261 664559 592475 624391 181804 420163 826317 820383 650038 596752 805986 764203 759927 238244 571997 564197 457358 382006 409076 508694 237950 483658 509544 383656 790076 801081 770226 409224 574768 571855 592914 603181 775858 517697 555990 428616 433039 492003 486738 553248 675692 798743 807902 786842 469173 402346 818795 815074 533057 705144 636578 642622 595946 780278 801094 758573 750914 742714 644510 699444 786384 812265 429527 405221 774215 555983 423513 495957 544525 404036 73421 461418 460251 477137 543792 565684 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (1.41%) |
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 73421 181804 187353 193299 237950 238244 382006 383656 386017 386627 388791 390927 402346 403418 404036 405221 409076 409224 420163 421569 423513 426104 428616 429527 431719 433039 457358 460251 461418 463728 465926 469171 469173 477137 479893 483658 486738 492003 494247 495957 499261 508694 509544 515855 517697 528572 533057 538565 543792 544525 553248 554053 555983 555990 560052 564197 565684 571855 571997 574768 582997 586404 592475 592914 595946 596033 596752 598388 603181 609644 624391 636578 642622 644510 650038 664559 675055 675692 683404 689061 699444 705136 705144 709646 725130 731660 740497 742714 744226 750914 756458 757074 758573 759882 759927 764203 770226 774215 775858 780278 780311 785967 786384 786842 789278 790076 792012 798743 801081 801094 802220 805986 807255 807902 812265 813767 815074 818795 820383 826317 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sexy чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexy stockings"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sexy чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.