Query Metrics
7
Database Queries
7
Different statements
209.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
181.77 ms (86.91%) |
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 519012 525529 541332 541592 541605 541625 541636 541674 541693 541725 541728 541781 541806 541895 542190 542198 542798 543471 544261 544862 545517 547552 550227 550336 551847 556759 556786 558009 560387 560430 562837 562839 562841 562843 562961 563530 564519 565102 566146 566243 566502 566503 566691 566697 567397 567408 567420 567429 568306 569427 571024 571241 571434 571445 572544 573764 573906 573909 574269 576350 576636 576686 577349 577364 577365 577366 577369 577370 577374 577377 577384 577386 578257 578952 580254 580255 580257 581269 581300 581301 581302 581313 581341 581349 581352 581383 581398 583854 587763 587797 592413 592437 592483 592492 593878 595770 597117 600316 604060 605306 605323 605338 605345 609568 619409 619468 620934 621709 622382 622953 624152 625279 625798 626732 628294 628329 644292 663507 670955 726860 ] |
||||||||||||||||||||||||||||||
|
17.14 ms (8.19%) |
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 556786 566691 567397 567408 573906 577386 581313 587763 587797 592492 593878 620934 644292 609568 622382 600316 592413 595770 621709 628329 625279 519012 541332 541725 542190 547552 550227 576350 576636 576686 542798 564519 567420 568306 569427 571024 581269 581352 541674 541781 558009 560430 562839 562843 562961 574269 670955 563530 577369 577370 577374 577377 580254 580255 581341 624152 605323 619409 619468 597117 625798 525529 542198 544862 560387 577364 577365 578952 541605 541625 541895 544261 562841 566697 567429 571445 541636 541693 566146 577384 581300 581302 581383 581398 583854 663507 545517 551847 562837 565102 571241 572544 573764 592437 592483 605345 622953 628294 626732 605338 541728 556759 726860 541806 566502 577349 581301 566503 571434 577366 581349 541592 543471 566243 573909 578257 550336 580257 604060 605306 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.50%) |
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 519012 525529 541332 541592 541605 541625 541636 541674 541693 541725 541728 541781 541806 541895 542190 542198 542798 543471 544261 544862 545517 547552 550227 550336 551847 556759 556786 558009 560387 560430 562837 562839 562841 562843 562961 563530 564519 565102 566146 566243 566502 566503 566691 566697 567397 567408 567420 567429 568306 569427 571024 571241 571434 571445 572544 573764 573906 573909 574269 576350 576636 576686 577349 577364 577365 577366 577369 577370 577374 577377 577384 577386 578257 578952 580254 580255 580257 581269 581300 581301 581302 581313 581341 581349 581352 581383 581398 583854 587763 587797 592413 592437 592483 592492 593878 595770 597117 600316 604060 605306 605323 605338 605345 609568 619409 619468 620934 621709 622382 622953 624152 625279 625798 626732 628294 628329 644292 663507 670955 726860 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny retro"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые ретр"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые ретр"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.77%) |
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.