Query Metrics
7
Database Queries
7
Different statements
169.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.94 ms (82.00%) |
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 392754 400185 401064 412262 414938 418440 418591 421043 425003 428756 430313 432034 433770 433966 443832 444703 445883 445890 446022 446031 448519 449723 450426 451493 454929 456480 457419 457856 460197 483321 485998 486539 488199 488378 490093 490424 490430 497424 498491 499121 500268 501148 502144 503110 505843 506278 507245 510222 512659 513776 514357 515018 515031 518085 521537 523351 524245 525142 525265 527982 529202 531073 533623 535450 538001 538008 538009 538273 539951 540968 542021 549822 549824 549829 549839 549840 549845 550219 551816 556806 558055 559067 560400 563552 564826 568344 568558 569097 569232 571495 575710 576990 579371 580177 580214 587397 589108 589681 590809 600007 601848 602959 603084 604243 604419 621543 647901 648144 652289 714867 725230 728452 730352 736770 744430 760958 775809 779584 788249 795212 ] |
||||||||||||||||||||||||||||||
|
20.16 ms (11.90%) |
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 575710 579371 550219 568344 569232 560400 580177 549822 563552 621543 730352 603084 425003 414938 448519 538273 498491 538001 538008 538009 568558 460197 551816 525265 531073 523351 549839 559067 728452 444703 486539 535450 725230 449723 454929 499121 488199 542021 571495 576990 558055 600007 589108 788249 736770 443832 446022 515031 400185 445883 457856 502144 518085 485998 556806 580214 647901 549840 587397 602959 456480 392754 433966 421043 540968 490093 513776 521537 527982 490424 524245 514357 428756 590809 775809 430313 412262 451493 488378 515018 549829 569097 760958 529202 483321 490430 497424 500268 512659 564826 604419 714867 604243 779584 549845 401064 505843 506278 648144 744430 795212 445890 503110 501148 533623 525142 539951 652289 549824 589681 601848 432034 418591 457419 507245 418440 433770 450426 446031 510222 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.59%) |
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 392754 400185 401064 412262 414938 418440 418591 421043 425003 428756 430313 432034 433770 433966 443832 444703 445883 445890 446022 446031 448519 449723 450426 451493 454929 456480 457419 457856 460197 483321 485998 486539 488199 488378 490093 490424 490430 497424 498491 499121 500268 501148 502144 503110 505843 506278 507245 510222 512659 513776 514357 515018 515031 518085 521537 523351 524245 525142 525265 527982 529202 531073 533623 535450 538001 538008 538009 538273 539951 540968 542021 549822 549824 549829 549839 549840 549845 550219 551816 556806 558055 559067 560400 563552 564826 568344 568558 569097 569232 571495 575710 576990 579371 580177 580214 587397 589108 589681 590809 600007 601848 602959 603084 604243 604419 621543 647901 648144 652289 714867 725230 728452 730352 736770 744430 760958 775809 779584 788249 795212 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step anal"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step анал"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step анал"
]
|
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.