Query Metrics
7
Database Queries
7
Different statements
176.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.23 ms (86.42%) |
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 11377 327170 383548 400728 403142 404870 416539 418492 419648 419824 424312 426358 429205 439577 446160 447575 448854 448860 452283 452587 455132 462931 463795 465239 469327 471316 472781 476232 478215 482775 484223 488929 495399 499628 499830 501223 504002 507817 508885 509678 510222 511244 511376 511562 514949 518472 519487 520630 520740 521551 523396 526029 526241 526267 526268 530019 532370 533623 535442 539292 541851 543477 543576 544202 544425 544477 544563 544828 548262 549247 549568 550035 550077 550820 551921 557186 559682 561117 562511 564546 566031 567424 569176 570748 574559 575806 576628 576721 577355 580254 580472 584709 585960 594208 596501 596583 598279 598918 600114 600167 601659 602249 603807 605306 605708 606387 606801 612964 621312 628267 648256 652586 652833 653452 656925 672469 677357 678982 679379 679387 ] |
||||||||||||||||||||||||||||||
|
14.09 ms (8.00%) |
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 400728 448854 452587 482775 469327 508885 526029 511562 532370 472781 562511 577355 543477 544563 549568 566031 576721 557186 678982 679379 648256 677357 551921 580254 594208 596583 596501 621312 419648 416539 426358 418492 447575 478215 404870 495399 507817 511244 484223 501223 429205 548262 403142 11377 383548 419824 471316 539292 499830 526241 544425 574559 580472 541851 550820 656925 559682 602249 606387 585960 606801 446160 327170 439577 514949 520740 535442 518472 569176 544202 653452 672469 584709 603807 598279 605306 424312 523396 564546 465239 550077 652586 605708 628267 504002 452283 463795 521551 510222 530019 476232 543576 544477 549247 550035 570748 544828 612964 598918 600114 600167 601659 448860 455132 511376 488929 462931 533623 499628 509678 520630 526267 526268 519487 561117 567424 576628 575806 652833 679387 ] |
||||||||||||||||||||||||||||||
|
3.25 ms (1.85%) |
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 11377 327170 383548 400728 403142 404870 416539 418492 419648 419824 424312 426358 429205 439577 446160 447575 448854 448860 452283 452587 455132 462931 463795 465239 469327 471316 472781 476232 478215 482775 484223 488929 495399 499628 499830 501223 504002 507817 508885 509678 510222 511244 511376 511562 514949 518472 519487 520630 520740 521551 523396 526029 526241 526267 526268 530019 532370 533623 535442 539292 541851 543477 543576 544202 544425 544477 544563 544828 548262 549247 549568 550035 550077 550820 551921 557186 559682 561117 562511 564546 566031 567424 569176 570748 574559 575806 576628 576721 577355 580254 580472 584709 585960 594208 596501 596583 598279 598918 600114 600167 601659 602249 603807 605306 605708 606387 606801 612964 621312 628267 648256 652586 652833 653452 656925 672469 677357 678982 679379 679387 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"лежа анал"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"леж анал"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.28 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.