Query Metrics
7
Database Queries
7
Different statements
178.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.49 ms (85.01%) |
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 314133 383430 384808 385163 385483 386623 397481 397662 403021 409106 409783 414211 428354 429978 429982 430014 430016 430023 430379 430468 430728 430732 430737 430748 430762 430786 430792 430796 430802 430805 430808 430818 430838 430915 430977 431020 431026 431167 431193 431228 431314 431321 431341 431372 444477 447478 447689 448887 453202 457742 457801 464379 464651 466640 471412 471831 480241 483081 485461 487138 490000 491352 491359 502575 513689 516745 519890 524468 528074 546830 548625 550363 550616 551948 558197 559703 580978 582815 590738 596464 615756 615761 620879 631665 631913 634297 638326 641679 641928 645011 645247 650783 661280 663349 670402 671950 672077 690323 691860 720188 720925 731630 732777 735549 737332 744316 752155 755219 760967 776889 792627 795138 805543 808730 812364 812796 813133 814839 815232 823242 ] |
||||||||||||||||||||||||||||||
|
14.95 ms (8.39%) |
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 641679 813133 430802 430014 430379 735549 731630 314133 431314 431026 428354 430016 755219 480241 457742 431193 559703 672077 691860 631913 776889 620879 546830 430468 430805 524468 596464 737332 615756 431228 429982 732777 430915 430737 548625 550616 590738 641928 808730 430762 490000 631665 528074 430796 516745 760967 466640 431167 491359 485461 491352 645247 431020 444477 792627 403021 580978 823242 471412 638326 384808 430808 670402 383430 409106 430023 464379 397662 397481 661280 645011 812364 720188 752155 385163 795138 430818 409783 431321 448887 671950 690323 558197 634297 430748 430792 815232 650783 429978 814839 615761 812796 720925 457801 431372 744316 502575 385483 430728 550363 663349 805543 386623 430732 483081 453202 519890 551948 414211 430838 430977 447689 447478 513689 431341 430786 464651 582815 487138 471831 ] |
||||||||||||||||||||||||||||||
|
4.23 ms (2.38%) |
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 314133 383430 384808 385163 385483 386623 397481 397662 403021 409106 409783 414211 428354 429978 429982 430014 430016 430023 430379 430468 430728 430732 430737 430748 430762 430786 430792 430796 430802 430805 430808 430818 430838 430915 430977 431020 431026 431167 431193 431228 431314 431321 431341 431372 444477 447478 447689 448887 453202 457742 457801 464379 464651 466640 471412 471831 480241 483081 485461 487138 490000 491352 491359 502575 513689 516745 519890 524468 528074 546830 548625 550363 550616 551948 558197 559703 580978 582815 590738 596464 615756 615761 620879 631665 631913 634297 638326 641679 641928 645011 645247 650783 661280 663349 670402 671950 672077 690323 691860 720188 720925 731630 732777 735549 737332 744316 752155 755219 760967 776889 792627 795138 805543 808730 812364 812796 813133 814839 815232 823242 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"babes big tits"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"babes большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"babes большие сиськ"
]
|
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.