Query Metrics
7
Database Queries
7
Different statements
151.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.31 ms (84.81%) |
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 9637 12405 13450 24255 34486 55910 89205 100449 146547 159036 187973 188025 197609 212132 212982 229704 233570 276646 305556 311703 324241 325253 334474 381865 381995 382419 382540 382573 383431 383735 386974 387000 387245 388851 389451 390461 392611 398195 398853 398974 401844 402239 404077 405904 413109 416925 418903 432657 440892 444249 457011 458030 458736 459599 475048 477582 483990 484623 485348 490812 491360 492418 504212 505651 505935 508719 510342 512173 512200 515706 521214 522571 528675 530327 532070 534719 538831 540199 541962 544346 547058 549271 549780 554492 556855 559206 561480 564789 564798 567058 569726 572525 572734 573226 574143 577592 588344 594903 598615 605112 617074 619539 621112 621978 622354 634400 642113 655077 657145 659682 660934 663389 707310 717660 744770 817876 818924 825559 825611 827148 ] |
||||||||||||||||||||||||||||||
|
13.13 ms (8.68%) |
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 564798 744770 381995 13450 197609 89205 521214 541962 605112 212982 621112 383431 444249 619539 484623 508719 311703 9637 404077 540199 544346 655077 212132 324241 55910 276646 389451 440892 827148 534719 717660 561480 159036 818924 515706 530327 567058 573226 598615 505651 505935 457011 398974 402239 325253 416925 418903 491360 642113 382573 383735 390461 485348 392611 382419 522571 512200 387245 398853 405904 817876 825611 528675 492418 574143 659682 594903 634400 707310 386974 413109 305556 34486 12405 401844 477582 538831 510342 504212 577592 549271 559206 188025 387000 459599 483990 100449 572525 564789 334474 398195 432657 825559 490812 532070 554492 547058 569726 572734 657145 660934 556855 622354 588344 617074 382540 475048 233570 458736 229704 512173 549780 663389 621978 381865 146547 187973 458030 24255 388851 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (2.11%) |
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 9637 12405 13450 24255 34486 55910 89205 100449 146547 159036 187973 188025 197609 212132 212982 229704 233570 276646 305556 311703 324241 325253 334474 381865 381995 382419 382540 382573 383431 383735 386974 387000 387245 388851 389451 390461 392611 398195 398853 398974 401844 402239 404077 405904 413109 416925 418903 432657 440892 444249 457011 458030 458736 459599 475048 477582 483990 484623 485348 490812 491360 492418 504212 505651 505935 508719 510342 512173 512200 515706 521214 522571 528675 530327 532070 534719 538831 540199 541962 544346 547058 549271 549780 554492 556855 559206 561480 564789 564798 567058 569726 572525 572734 573226 574143 577592 588344 594903 598615 605112 617074 619539 621112 621978 622354 634400 642113 655077 657145 659682 660934 663389 707310 717660 744770 817876 818924 825559 825611 827148 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck skirt"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс юбк"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс юбк"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.98%) |
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.