Query Metrics
7
Database Queries
7
Different statements
168.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.49 ms (82.93%) |
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 409093 447944 541604 541605 541623 544261 544306 544862 545517 546747 547909 547913 547928 549764 549766 550233 550336 552123 554321 556783 556847 558004 559057 559059 559060 559066 560387 560390 560485 561590 561740 562826 562837 562963 562981 562993 563133 563137 563142 563156 563194 563195 563197 563200 563201 563208 563212 563213 563222 563227 563426 563436 563453 563455 566146 567110 567407 567423 567424 567429 568362 572766 574231 576650 576655 576673 577356 577366 579345 581300 581301 581349 581398 583851 583854 583856 583860 583897 583902 584104 586294 589692 589761 590417 590421 591294 592462 592479 592530 593529 595842 597031 598067 601337 603147 605338 608354 611365 611505 614258 622331 622381 622953 622975 624789 624790 624793 628294 645925 648598 650494 690899 691510 692428 694072 694181 694443 709748 731305 748471 ] |
||||||||||||||||||||||||||||||
|
18.83 ms (11.20%) |
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 731305 748471 624790 447944 622975 560390 563195 583851 549766 554321 559059 563156 563200 572766 584104 544306 561740 563142 567407 576655 645925 650494 691510 692428 694443 648598 694072 556847 563137 563213 563222 563426 567423 586294 590417 590421 608354 595842 611505 409093 544862 546747 552123 559060 560387 567424 541605 544261 567429 576650 562826 566146 581300 581398 583854 709748 690899 545517 562837 563133 589761 593529 624793 622953 628294 591294 592479 598067 614258 592530 603147 605338 622381 577356 583856 576673 579345 581301 577366 581349 541604 550233 550336 556783 583897 622331 541623 561590 567110 547909 547928 559057 560485 563194 563208 563212 563436 574231 583902 547913 558004 559066 562981 562993 563455 694181 549764 562963 563197 563201 563227 563453 568362 583860 601337 592462 624789 611365 589692 597031 ] |
||||||||||||||||||||||||||||||
|
2.53 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 409093 447944 541604 541605 541623 544261 544306 544862 545517 546747 547909 547913 547928 549764 549766 550233 550336 552123 554321 556783 556847 558004 559057 559059 559060 559066 560387 560390 560485 561590 561740 562826 562837 562963 562981 562993 563133 563137 563142 563156 563194 563195 563197 563200 563201 563208 563212 563213 563222 563227 563426 563436 563453 563455 566146 567110 567407 567423 567424 567429 568362 572766 574231 576650 576655 576673 577356 577366 579345 581300 581301 581349 581398 583851 583854 583856 583860 583897 583902 584104 586294 589692 589761 590417 590421 591294 592462 592479 592530 593529 595842 597031 598067 601337 603147 605338 608354 611365 611505 614258 622331 622381 622953 622975 624789 624790 624793 628294 645925 648598 650494 690899 691510 692428 694072 694181 694443 709748 731305 748471 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"retro young"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ретр young"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.95%) |
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.