Query Metrics
7
Database Queries
7
Different statements
136.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
113.97 ms (83.32%) |
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 20886 21108 185334 213136 273182 281431 285321 317820 384336 387527 387830 389182 398609 400854 401507 413732 418540 419140 420250 423398 428267 428913 429544 443523 444005 446478 446480 447928 452533 457407 458834 460474 460950 468616 468753 469803 472949 473774 477408 491454 492637 500684 505353 515279 530667 530928 532925 536096 540310 540313 550639 551002 551950 551962 551975 551978 552002 552884 552934 554435 556384 556400 556418 558430 559849 559860 559907 559928 565202 565492 566465 572721 573213 575351 582669 585381 593227 593481 595056 597263 600455 601133 605397 606688 607763 613857 618318 621025 622336 622625 622643 622646 672717 673044 674463 678758 685259 685814 693148 699392 702757 709577 709649 712181 712184 713197 713474 722438 730579 730659 741098 743069 748672 766626 772105 792763 795708 810416 811868 826104 ] |
||||||||||||||||||||||||||||||
|
14.46 ms (10.57%) |
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 766626 429544 447928 469803 460474 556418 559928 552884 593227 20886 398609 384336 532925 551002 558430 554435 559849 575351 685259 699392 712181 678758 693148 722438 565202 622643 618318 730659 741098 772105 792763 702757 709577 713474 811868 387830 601133 551950 613857 185334 317820 413732 491454 500684 505353 550639 551962 551978 572721 556400 621025 622625 452533 444005 285321 457407 536096 559860 565492 559907 606688 593481 420250 273182 281431 530928 709649 672717 674463 622336 595056 743069 748672 622646 401507 826104 21108 458834 460950 556384 566465 685814 712184 673044 713197 607763 795708 600455 730579 515279 387527 418540 419140 428267 428913 446480 477408 468616 473774 540310 540313 552002 582669 573213 605397 810416 468753 443523 472949 530667 597263 446478 400854 585381 423398 213136 389182 492637 551975 552934 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.55%) |
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 20886 21108 185334 213136 273182 281431 285321 317820 384336 387527 387830 389182 398609 400854 401507 413732 418540 419140 420250 423398 428267 428913 429544 443523 444005 446478 446480 447928 452533 457407 458834 460474 460950 468616 468753 469803 472949 473774 477408 491454 492637 500684 505353 515279 530667 530928 532925 536096 540310 540313 550639 551002 551950 551962 551975 551978 552002 552884 552934 554435 556384 556400 556418 558430 559849 559860 559907 559928 565202 565492 566465 572721 573213 575351 582669 585381 593227 593481 595056 597263 600455 601133 605397 606688 607763 613857 618318 621025 622336 622625 622643 622646 672717 673044 674463 678758 685259 685814 693148 699392 702757 709577 709649 712181 712184 713197 713474 722438 730579 730659 741098 743069 748672 766626 772105 792763 795708 810416 811868 826104 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian girls"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк девушк"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"азиатк девушк"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.98%) |
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.