Query Metrics
7
Database Queries
7
Different statements
266.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
242.75 ms (91.08%) |
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 69704 70476 81510 81637 107905 336860 392534 401854 414682 426211 590739 609233 629558 700689 717149 717181 721845 724152 724729 725025 725479 726293 726442 726454 727298 727413 728131 730088 731054 731421 733356 734213 734524 734696 736358 738114 738898 738911 739920 739987 740246 740609 741318 743385 746432 746580 746612 747853 749538 750224 750276 752499 753172 755959 757006 757259 757803 758836 760562 760624 761104 761160 761546 763393 763475 767440 767798 768334 768356 769366 772863 773639 773691 773883 776984 777033 777046 777627 778221 778270 779014 779084 782689 783355 783937 785313 786101 786160 788091 788259 788265 790398 792166 793357 793454 793853 794194 794569 794587 794762 795107 795960 796117 797045 797286 799481 800390 801300 801987 803406 803448 804301 805400 807849 809640 810344 812157 812443 813211 824800 ] |
||||||||||||||||||||||||||||||
|
13.72 ms (5.15%) |
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 776984 777046 777627 792166 793454 794194 795107 803406 807849 812443 777033 779014 779084 782689 788259 788265 790398 793853 794569 799481 804301 805400 810344 725479 726442 727413 733356 734213 743385 753172 757006 760562 763393 772863 773639 783355 785313 786101 786160 788091 793357 794587 794762 795960 801987 809640 813211 725025 726454 730088 731054 731421 734524 736358 738898 739920 746612 755959 757803 761104 763475 724729 728131 738911 740246 746432 746580 749538 750224 750276 752499 773691 773883 724152 726293 747853 768334 768356 769366 727298 734696 738114 739987 740609 741318 757259 758836 760624 761160 761546 767440 767798 609233 629558 700689 717149 717181 721845 778221 778270 783937 796117 797045 797286 800390 801300 803448 812157 70476 81510 81637 401854 69704 426211 414682 107905 392534 336860 824800 590739 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.15%) |
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 69704 70476 81510 81637 107905 336860 392534 401854 414682 426211 590739 609233 629558 700689 717149 717181 721845 724152 724729 725025 725479 726293 726442 726454 727298 727413 728131 730088 731054 731421 733356 734213 734524 734696 736358 738114 738898 738911 739920 739987 740246 740609 741318 743385 746432 746580 746612 747853 749538 750224 750276 752499 753172 755959 757006 757259 757803 758836 760562 760624 761104 761160 761546 763393 763475 767440 767798 768334 768356 769366 772863 773639 773691 773883 776984 777033 777046 777627 778221 778270 779014 779084 782689 783355 783937 785313 786101 786160 788091 788259 788265 790398 792166 793357 793454 793853 794194 794569 794587 794762 795107 795960 796117 797045 797286 799481 800390 801300 801987 803406 803448 804301 805400 807849 809640 810344 812157 812443 813211 824800 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"компиляций"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.69%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"подборк"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.65%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.57%) |
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.