Query Metrics
7
Database Queries
7
Different statements
155.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.40 ms (79.91%) |
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 89480 382134 382502 384752 390898 395637 397219 428138 440868 443761 443772 443782 453145 454194 465560 466244 466319 467243 467427 467488 467541 469283 470017 470148 472592 472608 475205 475884 476272 476346 479031 479034 479061 479084 479091 480921 483362 483646 484594 484621 484625 484725 490187 490195 490197 490917 490918 492062 493177 497205 497506 508736 510889 511541 511594 514369 514688 515841 515905 515912 515917 518846 518909 519306 520864 520899 520920 522480 522508 523845 523847 523852 523874 524778 525847 526516 526701 526703 526711 530326 531970 535439 536457 537484 538006 542787 543694 551507 560389 560430 563094 563096 563413 567344 589752 614514 619531 664846 666770 667615 710445 714169 716487 720121 725197 726549 726756 731755 731772 731836 734015 744906 748228 780625 792660 819032 819117 819241 823847 825248 ] |
||||||||||||||||||||||||||||||
|
21.75 ms (13.97%) |
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 466244 470017 443761 443772 443782 454194 520899 523874 536457 538006 484594 484625 492062 515905 515912 518909 519306 523845 490197 497205 508736 522508 483646 484621 493177 515841 535439 780625 823847 497506 716487 714169 664846 666770 667615 726756 731772 734015 731836 731755 744906 397219 89480 384752 395637 382134 453145 472608 490187 465560 531970 526701 526703 472592 479084 560389 542787 563096 563094 567344 589752 614514 725197 792660 748228 726549 619531 710445 720121 467243 479034 382502 467541 475205 390898 466319 469283 470148 476346 480921 428138 440868 467427 476272 479061 479091 467488 475884 479031 514369 514688 522480 523847 520920 526711 483362 490918 511594 515917 524778 525847 526516 484725 490195 490917 510889 511541 518846 520864 523852 819032 563413 560430 819117 819241 825248 530326 537484 543694 551507 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.91%) |
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 89480 382134 382502 384752 390898 395637 397219 428138 440868 443761 443772 443782 453145 454194 465560 466244 466319 467243 467427 467488 467541 469283 470017 470148 472592 472608 475205 475884 476272 476346 479031 479034 479061 479084 479091 480921 483362 483646 484594 484621 484625 484725 490187 490195 490197 490917 490918 492062 493177 497205 497506 508736 510889 511541 511594 514369 514688 515841 515905 515912 515917 518846 518909 519306 520864 520899 520920 522480 522508 523845 523847 523852 523874 524778 525847 526516 526701 526703 526711 530326 531970 535439 536457 537484 538006 542787 543694 551507 560389 560430 563094 563096 563413 567344 589752 614514 619531 664846 666770 667615 710445 714169 716487 720121 725197 726549 726756 731755 731772 731836 734015 744906 748228 780625 792660 819032 819117 819241 823847 825248 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big but mature"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие mature"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие mature"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.93%) |
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.