Query Metrics
7
Database Queries
7
Different statements
167.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.94 ms (82.86%) |
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 447944 525529 541604 541605 541623 544261 544306 544862 545517 546747 547909 547913 547928 549758 549764 549766 549773 550225 550233 550336 552123 554321 554900 556783 558004 559057 559059 559060 559066 560387 560390 560485 561590 561740 562837 562981 562993 563123 563133 563139 563142 563153 563156 563194 563195 563200 563208 563212 563213 563222 563426 563455 566011 566146 567110 567407 567423 567424 567429 572766 576650 576655 576673 577356 577366 577369 581300 581301 581398 583851 583854 583902 584250 586294 589761 590417 590421 591294 592479 593529 595842 598067 603147 605323 605338 608354 610595 611505 614258 616341 618868 619409 622381 622855 622953 622975 624790 624793 625798 628292 628294 628315 645925 648598 690899 691186 691510 692428 694058 694072 694181 694443 699697 709748 714470 731305 742610 748471 754156 790392 ] |
||||||||||||||||||||||||||||||
|
17.54 ms (10.46%) |
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 691186 694058 699697 577369 610595 628315 605323 618868 628292 619409 625798 790392 525529 549773 549758 566011 550225 563123 563139 563153 584250 714470 554900 622855 616341 754156 742610 731305 748471 624790 447944 622975 560390 563195 583851 549766 554321 559059 563156 563200 572766 544306 561740 563142 567407 576655 645925 691510 692428 694443 648598 694072 563213 563222 563426 567423 586294 590417 590421 608354 595842 611505 544862 546747 552123 559060 560387 567424 541605 544261 567429 576650 566146 581300 581398 583854 709748 690899 545517 562837 563133 589761 593529 624793 622953 628294 591294 592479 598067 614258 603147 605338 622381 577356 576673 581301 577366 541604 550233 550336 556783 541623 561590 567110 547909 547928 559057 560485 563194 563208 563212 583902 547913 558004 559066 562981 562993 563455 694181 549764 ] |
||||||||||||||||||||||||||||||
|
3.84 ms (2.29%) |
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 447944 525529 541604 541605 541623 544261 544306 544862 545517 546747 547909 547913 547928 549758 549764 549766 549773 550225 550233 550336 552123 554321 554900 556783 558004 559057 559059 559060 559066 560387 560390 560485 561590 561740 562837 562981 562993 563123 563133 563139 563142 563153 563156 563194 563195 563200 563208 563212 563213 563222 563426 563455 566011 566146 567110 567407 567423 567424 567429 572766 576650 576655 576673 577356 577366 577369 581300 581301 581398 583851 583854 583902 584250 586294 589761 590417 590421 591294 592479 593529 595842 598067 603147 605323 605338 608354 610595 611505 614258 616341 618868 619409 622381 622855 622953 622975 624790 624793 625798 628292 628294 628315 645925 648598 690899 691186 691510 692428 694058 694072 694181 694443 699697 709748 714470 731305 742610 748471 754156 790392 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young retro"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young ретр"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young ретр"
]
|
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.