Query Metrics
7
Database Queries
7
Different statements
291.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
265.90 ms (91.10%) |
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 249773 366478 381767 385292 390634 392461 395985 397114 398008 400005 404263 404358 411849 419073 420023 421277 423792 426117 433206 437523 438212 443315 443322 443524 444972 446358 447416 461090 461621 463868 466930 467225 467558 475965 477970 478009 478463 484084 486059 486304 487088 488957 489522 489691 490093 490525 492234 492459 492693 495317 496247 497894 500494 501245 502575 504836 506557 507963 508493 508550 512313 513659 513662 518291 518501 518956 519551 519980 521860 522055 522432 522907 523699 525897 526899 527610 528455 529760 530756 530824 533273 537201 538166 538460 539131 539278 539283 540058 541050 543106 545607 548735 548994 551329 551455 553263 556080 566324 567082 576244 690468 693830 699670 702170 748674 757146 766862 783955 792702 814641 820430 821096 821489 821518 821991 822303 823494 823528 823759 825714 ] |
||||||||||||||||||||||||||||||
|
16.24 ms (5.57%) |
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 748674 766862 757146 783955 792702 366478 392461 397114 398008 385292 419073 433206 443524 444972 411849 461090 466930 484084 478463 492459 519551 539278 518501 530756 537201 506557 519980 545607 566324 548735 567082 426117 443315 467558 421277 423792 437523 443322 478009 390634 404263 447416 475965 518291 522907 490093 492234 513659 528455 504836 508493 513662 523699 486304 488957 489522 489691 495317 502575 507963 512313 249773 395985 381767 400005 404358 438212 420023 821096 823759 820430 821518 821991 822303 823494 814641 821489 823528 825714 467225 487088 490525 446358 461621 463868 492693 501245 521860 527610 530824 533273 538166 496247 522055 522432 525897 538460 540058 518956 497894 500494 508550 526899 529760 539131 539283 477970 486059 541050 553263 548994 576244 543106 551329 551455 556080 693830 699670 702170 690468 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (0.94%) |
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 249773 366478 381767 385292 390634 392461 395985 397114 398008 400005 404263 404358 411849 419073 420023 421277 423792 426117 433206 437523 438212 443315 443322 443524 444972 446358 447416 461090 461621 463868 466930 467225 467558 475965 477970 478009 478463 484084 486059 486304 487088 488957 489522 489691 490093 490525 492234 492459 492693 495317 496247 497894 500494 501245 502575 504836 506557 507963 508493 508550 512313 513659 513662 518291 518501 518956 519551 519980 521860 522055 522432 522907 523699 525897 526899 527610 528455 529760 530756 530824 533273 537201 538166 538460 539131 539278 539283 540058 541050 543106 545607 548735 548994 551329 551455 553263 556080 566324 567082 576244 690468 693830 699670 702170 748674 757146 766862 783955 792702 814641 820430 821096 821489 821518 821991 822303 823494 823528 823759 825714 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.66%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"white худые"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.63%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"white худые"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"white skinny"
]
|
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.