Query Metrics
7
Database Queries
7
Different statements
168.05 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.70 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.97 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl live"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.51 ms |
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 416511 459657 707695 707687 587524 601815 418719 412180 669919 546758 386684 418142 418720 569050 543409 550608 602194 477182 515464 464659 511856 662143 641436 629042 416038 522560 452843 728336 416596 416614 416626 452923 493864 505376 522559 567677 775321 491409 520618 510765 543435 556935 707689 619497 587216 634867 452496 437789 526582 464737 457147 449122 418145 493916 416025 520692 530943 602186 483735 527706 420918 418144 483352 443247 644915 443246 470106 745939 495220 418122 485591 430344 429369 447096 670745 619777 445409 484958 584208 636231 504085 584887 520138 ] |
||||||||||||||||||||||||||||||
| 4 | 2.68 ms |
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 386684 412180 416025 416038 416511 416596 416614 416626 418122 418142 418144 418145 418719 418720 420918 429369 430344 437789 443246 443247 445409 447096 449122 452496 452843 452923 457147 459657 464659 464737 470106 477182 483352 483735 484958 485591 491409 493864 493916 495220 504085 505376 510765 511856 515464 520138 520618 520692 522559 522560 526582 527706 530943 543409 543435 546758 550608 556935 567677 569050 584208 584887 587216 587524 601815 602186 602194 619497 619777 629042 634867 636231 641436 644915 662143 669919 670745 707687 707689 707695 728336 745939 775321 ] |
||||||||||||||||||||||||||||||
| 5 | 142.80 ms |
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 386684 412180 416025 416038 416511 416596 416614 416626 418122 418142 418144 418145 418719 418720 420918 429369 430344 437789 443246 443247 445409 447096 449122 452496 452843 452923 457147 459657 464659 464737 470106 477182 483352 483735 484958 485591 491409 493864 493916 495220 504085 505376 510765 511856 515464 520138 520618 520692 522559 522560 526582 527706 530943 543409 543435 546758 550608 556935 567677 569050 584208 584887 587216 587524 601815 602186 602194 619497 619777 629042 634867 636231 641436 644915 662143 669919 670745 707687 707689 707695 728336 745939 775321 ] |
||||||||||||||||||||||||||||||
| 6 | 1.83 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк live"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.56 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк live"
]
|
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.