Query Metrics
7
Database Queries
7
Different statements
176.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.62 ms (86.26%) |
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 361286 383162 385040 391208 395237 396278 396780 401724 405990 408047 410132 411880 416128 417660 418528 419764 419906 419914 420206 420216 420499 420613 421198 422832 423202 428458 428518 429541 430273 432136 438765 445054 445879 446217 446266 446355 446882 450399 451961 452054 454685 456633 456929 458101 458369 458382 460022 464714 467744 468553 469536 473756 473766 492815 497453 497459 507258 507670 512172 512218 513087 513193 517685 519291 521048 527610 529833 531222 540175 543919 550721 556428 559162 559943 565475 566845 574467 574940 575344 590280 596514 602491 605848 610201 622201 623822 624831 628916 637757 649870 651979 653843 655882 688319 691050 718677 718994 720872 724590 727633 727853 730872 731576 733885 733905 733913 743069 747952 748670 749812 753216 761468 762110 785005 792337 807970 808775 822075 827831 827832 ] |
||||||||||||||||||||||||||||||
|
13.99 ms (7.91%) |
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 385040 575344 628916 762110 418528 456633 420206 827831 512172 391208 419906 417660 452054 464714 473766 512218 513193 521048 419914 438765 822075 623822 383162 411880 430273 423202 446355 456929 497453 531222 540175 507258 473756 624831 610201 733885 733905 727633 432136 446882 408047 460022 517685 519291 543919 748670 559943 556428 720872 429541 550721 428518 458101 651979 574940 605848 792337 808775 420499 565475 566845 649870 653843 785005 747952 458369 691050 622201 733913 727853 655882 688319 718677 718994 637757 743069 753216 724590 731576 749812 807970 445879 596514 574467 467744 419764 420216 468553 422832 602491 361286 416128 445054 446217 451961 454685 492815 513087 529833 761468 458382 450399 497459 405990 396278 420613 428458 469536 446266 590280 410132 507670 730872 827832 527610 559162 395237 396780 401724 421198 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (1.85%) |
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 361286 383162 385040 391208 395237 396278 396780 401724 405990 408047 410132 411880 416128 417660 418528 419764 419906 419914 420206 420216 420499 420613 421198 422832 423202 428458 428518 429541 430273 432136 438765 445054 445879 446217 446266 446355 446882 450399 451961 452054 454685 456633 456929 458101 458369 458382 460022 464714 467744 468553 469536 473756 473766 492815 497453 497459 507258 507670 512172 512218 513087 513193 517685 519291 521048 527610 529833 531222 540175 543919 550721 556428 559162 559943 565475 566845 574467 574940 575344 590280 596514 602491 605848 610201 622201 623822 624831 628916 637757 649870 651979 653843 655882 688319 691050 718677 718994 720872 724590 727633 727853 730872 731576 733885 733905 733913 743069 747952 748670 749812 753216 761468 762110 785005 792337 807970 808775 822075 827831 827832 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big dick asian"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большой большие член азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.