Query Metrics
7
Database Queries
7
Different statements
160.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.41 ms (83.97%) |
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 7086 76268 99145 219957 280580 373048 395724 396014 396282 397284 398698 403375 403463 403468 403965 404300 413077 413991 424817 429405 432081 432890 435503 438952 452322 456079 465630 471646 477516 485802 510199 515632 515649 523051 530037 549818 569958 585339 589951 593831 616026 626351 632192 642412 644953 648906 650738 664731 676208 682276 702232 710197 710228 726809 727391 728238 736644 737195 738937 746103 747183 750450 750770 752363 752812 754891 755430 759880 760527 760673 763216 763301 763771 765786 768182 769314 770508 772146 774204 776665 776668 784852 785050 785496 795049 796828 797500 798075 799560 801337 801511 801515 803773 804196 807623 808478 811004 811557 812187 812721 812886 813349 813607 813782 815398 816778 817848 817945 818166 818865 820356 820696 821689 822421 822913 824582 825056 825448 827784 ] |
||||||||||||||||||||||||||||||
|
14.40 ms (9.00%) |
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 760527 726809 763301 738937 752812 755430 760673 765786 807623 811557 626351 676208 456079 395724 396014 403965 589951 616026 798075 452322 413991 471646 438952 477516 515632 515649 373048 710228 398698 403375 435503 429405 465630 396282 403463 523051 485802 280580 818865 825056 644953 813607 817848 817945 818166 820356 820696 813782 816778 822421 824582 815398 821689 822913 825448 827784 530037 569958 664731 702232 650738 682276 710197 648906 549818 585339 642412 632192 784852 796828 797500 804196 812187 813349 799560 801515 812721 737195 746103 750450 752363 763216 772146 801511 808478 811004 812886 728238 736644 759141 759880 727391 768182 769314 747183 750770 754891 770508 763771 774204 776665 776668 785050 785496 795049 801337 803773 76268 219957 424817 510199 593831 432081 99145 432890 7086 397284 403468 404300 413077 ] |
||||||||||||||||||||||||||||||
|
3.62 ms (2.26%) |
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 7086 76268 99145 219957 280580 373048 395724 396014 396282 397284 398698 403375 403463 403468 403965 404300 413077 413991 424817 429405 432081 432890 435503 438952 452322 456079 465630 471646 477516 485802 510199 515632 515649 523051 530037 549818 569958 585339 589951 593831 616026 626351 632192 642412 644953 648906 650738 664731 676208 682276 702232 710197 710228 726809 727391 728238 736644 737195 738937 746103 747183 750450 750770 752363 752812 754891 755430 759880 760527 760673 763216 763301 763771 765786 768182 769314 770508 772146 774204 776665 776668 784852 785050 785496 795049 796828 797500 798075 799560 801337 801511 801515 803773 804196 807623 808478 811004 811557 812187 812721 812886 813349 813607 813782 815398 816778 817848 817945 818166 818865 820356 820696 821689 822421 822913 824582 825056 825448 827784 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big boobs latina"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие boobs латинская"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие boobs латинская"
]
|
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.