Query Metrics
7
Database Queries
7
Different statements
154.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.52 ms (83.81%) |
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 538847 538948 542938 543467 544308 546719 547859 547912 549780 556796 562779 562857 563433 566373 566394 566445 566866 566892 567993 568011 568187 570571 572173 573792 573855 573952 574204 583626 585998 587451 593402 598028 598768 605341 608352 609183 611030 622845 624156 624159 625017 629265 629955 638756 639282 644246 644894 645260 645838 648672 648963 649536 649947 651151 651217 651947 652573 652856 652988 653450 654130 667938 668154 670062 670388 670765 671747 671748 671878 672099 673497 674107 674119 677714 678432 678433 681703 685288 692008 692023 692265 692319 692330 692360 693041 693051 694172 694184 695236 696273 696974 697258 697328 697971 698405 699574 700275 703087 703433 703534 703535 705295 708790 714615 716590 717934 717947 719059 719062 720375 729245 741018 747100 747609 758116 784600 789629 791002 800629 811492 ] |
||||||||||||||||||||||||||||||
|
15.00 ms (9.71%) |
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 678432 694172 697258 697328 705295 717934 720375 645838 652573 652856 670388 671747 685288 692360 693041 708790 546719 556796 563433 566445 598028 585998 644246 622845 638756 639282 791002 811492 741018 747609 784600 800629 747100 729245 758116 609183 629955 696974 703087 703433 703535 719062 566866 547859 566892 699574 608352 574204 566373 644894 538948 538847 544308 566394 570571 573792 547912 549780 572173 542938 543467 583626 648672 649536 649947 651947 652988 654130 667938 670765 677714 678433 681703 692319 693051 695236 700275 719059 651217 668154 671748 692330 694184 696273 697971 714615 716590 645260 648963 651151 653450 670062 671878 672099 673497 674107 674119 692008 692023 692265 698405 703534 717947 562779 562857 567993 568011 568187 573855 573952 587451 593402 605341 624156 624159 598768 625017 611030 629265 789629 ] |
||||||||||||||||||||||||||||||
|
3.24 ms (2.10%) |
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 538847 538948 542938 543467 544308 546719 547859 547912 549780 556796 562779 562857 563433 566373 566394 566445 566866 566892 567993 568011 568187 570571 572173 573792 573855 573952 574204 583626 585998 587451 593402 598028 598768 605341 608352 609183 611030 622845 624156 624159 625017 629265 629955 638756 639282 644246 644894 645260 645838 648672 648963 649536 649947 651151 651217 651947 652573 652856 652988 653450 654130 667938 668154 670062 670388 670765 671747 671748 671878 672099 673497 674107 674119 677714 678432 678433 681703 685288 692008 692023 692265 692319 692330 692360 693041 693051 694172 694184 695236 696273 696974 697258 697328 697971 698405 699574 700275 703087 703433 703534 703535 705295 708790 714615 716590 717934 717947 719059 719062 720375 729245 741018 747100 747609 758116 784600 789629 791002 800629 811492 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen boy retro"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"молодой ретр"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.98%) |
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.