Query Metrics
7
Database Queries
7
Different statements
175.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.70 ms (76.06%) |
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 6669 20180 33379 61051 167756 182526 324183 366053 373852 382158 382246 385755 388642 395597 395999 397643 400788 401344 402266 403896 414048 417161 418009 418188 418528 419910 420252 420613 422511 422513 422550 422561 422572 422592 422649 422657 422879 422901 422909 422923 422925 422926 422929 422958 422960 423042 423245 423263 423283 423414 423418 427358 428801 429379 430468 433152 433279 443550 453019 457259 457882 458094 459237 466691 475443 475450 478025 482621 492732 497382 497444 500686 508962 511249 511264 511271 512680 518011 522198 530685 532941 535434 537201 537932 540187 543919 551991 559160 565344 567837 588228 590280 592380 593606 597275 598344 604319 604652 616612 619441 619445 623510 628422 651620 706946 709688 712158 720306 720872 744704 748661 748685 762296 765703 766607 767286 784161 820459 821892 822535 ] |
||||||||||||||||||||||||||||||
|
30.45 ms (17.32%) |
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 466691 530685 709688 400788 422561 422572 395999 619445 422901 422511 167756 619441 511249 420252 423414 382246 540187 511264 598344 623510 61051 616612 403896 422657 429379 522198 430468 766607 397643 592380 784161 551991 433152 366053 428801 422909 475450 762296 418528 395597 559160 748685 33379 423042 20180 422649 720306 590280 822535 419910 422592 821892 820459 508962 651620 422923 500686 767286 748661 373852 457882 422550 765703 478025 422513 497444 604652 324183 497382 588228 706946 543919 420613 418009 712158 537932 604319 422926 457259 597275 628422 511271 593606 418188 423263 453019 458094 422925 382158 422958 422879 401344 535434 537201 532941 720872 417161 565344 427358 6669 459237 744704 475443 512680 402266 492732 422929 385755 423418 423245 443550 182526 567837 388642 518011 422960 423283 433279 414048 482621 ] |
||||||||||||||||||||||||||||||
|
4.78 ms (2.72%) |
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 6669 20180 33379 61051 167756 182526 324183 366053 373852 382158 382246 385755 388642 395597 395999 397643 400788 401344 402266 403896 414048 417161 418009 418188 418528 419910 420252 420613 422511 422513 422550 422561 422572 422592 422649 422657 422879 422901 422909 422923 422925 422926 422929 422958 422960 423042 423245 423263 423283 423414 423418 427358 428801 429379 430468 433152 433279 443550 453019 457259 457882 458094 459237 466691 475443 475450 478025 482621 492732 497382 497444 500686 508962 511249 511264 511271 512680 518011 522198 530685 532941 535434 537201 537932 540187 543919 551991 559160 565344 567837 588228 590280 592380 593606 597275 598344 604319 604652 616612 619441 619445 623510 628422 651620 706946 709688 712158 720306 720872 744704 748661 748685 762296 765703 766607 767286 784161 820459 821892 822535 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"азиатки анал секс"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"азиатк анал секс"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.