Query Metrics
7
Database Queries
7
Different statements
591.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
568.60 ms (96.12%) |
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 7753 73413 102334 149261 185642 185861 236378 359054 382200 382650 383018 383984 386310 395509 399595 399628 405815 407064 417202 419147 429357 433058 433958 436588 442802 444460 444540 444635 445796 446011 447357 447664 450277 452334 454909 454942 455133 456058 460651 461039 463420 465079 465226 467110 468687 475711 478988 480848 482272 489897 499476 499821 502809 504339 509720 510205 511413 518590 522166 523871 524567 531442 533630 538973 548081 548097 551366 551407 555944 562398 562904 564619 564633 582636 586666 598061 601079 604030 604926 620329 634432 637037 641924 643097 645301 651881 661354 664528 664944 673052 674662 677975 701054 709554 710483 737722 743038 744709 747328 747363 753784 754666 759856 762556 769955 773875 790080 793624 801243 805328 805731 807910 817486 817806 818783 818784 820900 826302 828682 828714 ] |
||||||||||||||||||||||||||||||
|
12.69 ms (2.15%) |
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 399595 444460 417202 436588 452334 499821 661354 674662 598061 747328 433958 664944 444635 407064 820900 454942 564633 582636 651881 555944 475711 817806 828682 645301 677975 801243 754666 419147 433058 480848 454909 562398 604030 523871 817486 818783 826302 818784 637037 769955 744709 743038 383984 386310 236378 359054 828714 548097 673052 701054 709554 548081 620329 641924 793624 807910 737722 753784 149261 382650 382200 634432 586666 790080 773875 461039 643097 805328 551407 538973 383018 533630 759856 185642 460651 510205 562904 446011 465079 509720 511413 524567 502809 522166 664528 710483 601079 604926 805731 762556 747363 73413 102334 185861 395509 7753 399628 405815 442802 444540 429357 445796 447357 468687 447664 455133 467110 489897 450277 456058 465226 478988 518590 504339 499476 531442 463420 482272 551366 564619 ] |
||||||||||||||||||||||||||||||
|
3.71 ms (0.63%) |
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 7753 73413 102334 149261 185642 185861 236378 359054 382200 382650 383018 383984 386310 395509 399595 399628 405815 407064 417202 419147 429357 433058 433958 436588 442802 444460 444540 444635 445796 446011 447357 447664 450277 452334 454909 454942 455133 456058 460651 461039 463420 465079 465226 467110 468687 475711 478988 480848 482272 489897 499476 499821 502809 504339 509720 510205 511413 518590 522166 523871 524567 531442 533630 538973 548081 548097 551366 551407 555944 562398 562904 564619 564633 582636 586666 598061 601079 604030 604926 620329 634432 637037 641924 643097 645301 651881 661354 664528 664944 673052 674662 677975 701054 709554 710483 737722 743038 744709 747328 747363 753784 754666 759856 762556 769955 773875 790080 793624 801243 805328 805731 807910 817486 817806 818783 818784 820900 826302 828682 828714 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits oil"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ масл"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.26 ms (0.21%) |
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.