Query Metrics
7
Database Queries
7
Different statements
160.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.78 ms (84.63%) |
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 7169 311237 388200 396863 399837 400730 400812 402267 409942 415978 418369 422582 422590 422591 422594 422686 422711 429802 448033 451696 458051 462710 463889 464327 466215 466239 489120 490202 491475 507642 508199 508430 517013 521579 529175 532955 533747 536676 543872 544770 545602 545607 546112 546200 550350 557517 565198 565245 566416 570708 571212 571244 576717 577039 597142 597170 597262 598067 599835 599887 603285 609682 622401 624173 624223 628126 628292 628361 628367 630245 632025 636273 636274 640813 642033 643109 644674 647960 650158 663247 671667 677344 681843 711888 714109 714449 714464 715144 720790 720885 720938 722719 722796 722875 724176 725403 727050 727812 727924 729911 737164 741193 741306 742143 743057 758535 770187 774176 775797 784227 790392 796211 800262 805668 812097 815748 817308 821829 821851 ] |
||||||||||||||||||||||||||||||
|
13.66 ms (8.51%) |
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 422590 463889 490202 517013 532955 727050 550350 647960 597262 597170 415978 508199 521579 533747 545602 570708 671667 650158 546200 727812 396863 399837 603285 722796 466215 523324 529175 565198 546112 543872 630245 643109 598067 458051 466239 566416 571244 422686 422591 815748 821851 451696 557517 545607 571212 714109 714464 722875 681843 720885 544770 597142 632025 642033 624223 628292 628361 628367 636274 609682 636273 775797 742143 729911 724176 644674 714449 720938 790392 800262 429802 400812 418369 422711 491475 812097 422582 448033 622401 599887 422594 489120 388200 400730 663247 722719 677344 805668 741193 784227 796211 402267 821829 536676 565245 640813 464327 409942 711888 741306 311237 770187 758535 577039 727924 737164 774176 720790 743057 462710 508430 628126 599835 576717 715144 725403 507642 624173 817308 7169 ] |
||||||||||||||||||||||||||||||
|
4.12 ms (2.57%) |
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 7169 311237 388200 396863 399837 400730 400812 402267 409942 415978 418369 422582 422590 422591 422594 422686 422711 429802 448033 451696 458051 462710 463889 464327 466215 466239 489120 490202 491475 507642 508199 508430 517013 521579 529175 532955 533747 536676 543872 544770 545602 545607 546112 546200 550350 557517 565198 565245 566416 570708 571212 571244 576717 577039 597142 597170 597262 598067 599835 599887 603285 609682 622401 624173 624223 628126 628292 628361 628367 630245 632025 636273 636274 640813 642033 643109 644674 647960 650158 663247 671667 677344 681843 711888 714109 714449 714464 715144 720790 720885 720938 722719 722796 722875 724176 725403 727050 727812 727924 729911 737164 741193 741306 742143 743057 758535 770187 774176 775797 784227 790392 796211 800262 805668 812097 815748 817308 821829 821851 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal young tits"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал young сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал young сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.89%) |
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.