Query Metrics
7
Database Queries
7
Different statements
204.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.03 ms (86.23%) |
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 384452 398797 429144 429318 431333 529068 543162 543750 548609 550564 551002 551477 552192 552201 552222 552243 552467 552629 558852 565250 565255 565552 568513 569097 571643 574492 574897 575756 575790 576051 579358 583641 590295 596039 596625 597227 597476 597798 597823 597825 598039 598057 598135 598680 598787 600110 600330 603052 604266 605503 608015 621451 624170 628086 628090 628379 628388 632975 635117 641667 652955 652960 654826 656360 656785 657143 658728 659161 659283 660296 671325 671597 674943 683559 684312 691217 694492 699403 714444 715332 715453 718687 720223 720397 721302 721317 721851 722628 722649 729160 736959 740344 746802 746978 748663 749329 750316 752721 753340 753898 753902 754180 755634 758983 760966 774469 777652 781068 790384 792179 793982 796232 800390 805668 806331 806334 807519 818390 818531 828849 ] |
||||||||||||||||||||||||||||||
|
16.90 ms (8.28%) |
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 671325 552243 621451 748663 714444 774469 818390 818531 543750 552201 583641 550564 565552 568513 558852 659161 656360 660296 671597 683559 654826 656785 715332 590295 598787 604266 635117 596039 600110 740344 793982 746978 721317 796232 800390 674943 529068 543162 552629 657143 658728 720397 722628 652955 694492 720223 691217 722649 597798 597823 603052 598135 624170 807519 781068 792179 746802 750316 754180 755634 760966 805668 806331 752721 749329 753898 753902 729160 736959 753340 758983 699403 718687 721302 721851 777652 806334 384452 652960 576051 548609 574897 579358 551477 552467 565250 565255 574492 575756 575790 659283 684312 569097 598680 632975 597227 598057 600330 628086 628090 628379 628388 605503 641667 431333 571643 552222 715453 552192 596625 597825 597476 598039 608015 429144 429318 828849 551002 790384 398797 ] |
||||||||||||||||||||||||||||||
|
3.96 ms (1.94%) |
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 384452 398797 429144 429318 431333 529068 543162 543750 548609 550564 551002 551477 552192 552201 552222 552243 552467 552629 558852 565250 565255 565552 568513 569097 571643 574492 574897 575756 575790 576051 579358 583641 590295 596039 596625 597227 597476 597798 597823 597825 598039 598057 598135 598680 598787 600110 600330 603052 604266 605503 608015 621451 624170 628086 628090 628379 628388 632975 635117 641667 652955 652960 654826 656360 656785 657143 658728 659161 659283 660296 671325 671597 674943 683559 684312 691217 694492 699403 714444 715332 715453 718687 720223 720397 721302 721317 721851 722628 722649 729160 736959 740344 746802 746978 748663 749329 750316 752721 753340 753898 753902 754180 755634 758983 760966 774469 777652 781068 790384 792179 793982 796232 800390 805668 806331 806334 807519 818390 818531 828849 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen маленькая"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen small"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen маленькая"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.74%) |
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.