Query Metrics
7
Database Queries
7
Different statements
152.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.54 ms (86.09%) |
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 47689 167756 181252 188176 318795 379604 382581 389629 390389 399659 400811 401465 405825 408795 409984 411081 415805 415928 425973 428209 429298 437310 439475 440490 446940 447251 448166 449095 451471 452350 456297 460622 468672 469590 475293 477576 480959 486588 488955 506883 510045 513721 516487 519505 520674 536447 541339 542207 547059 548320 553178 558431 562965 584334 585162 587471 587472 596917 601905 604871 604934 606018 607522 625878 644217 651094 680980 692473 695107 697216 709894 710246 710297 710928 711891 719873 720243 720833 721936 726795 728308 732721 733032 733545 734011 738576 742714 750374 757909 758550 759607 759762 759884 764250 768387 770138 771211 771221 778490 794720 794921 795915 797352 801896 803498 807410 807597 811486 811745 814333 815358 819773 820678 822590 824180 824533 828146 828494 ] |
||||||||||||||||||||||||||||||
|
11.96 ms (7.82%) |
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 797352 733545 768387 764250 390389 389629 448166 399659 440490 415805 469590 475293 447251 558431 516487 486588 379604 828494 446940 400811 411081 437310 401465 519505 456297 709894 167756 449095 460622 468672 541339 720833 720243 318795 822590 815358 726795 732721 181252 405825 409984 428209 415928 477576 513721 548320 604934 606018 587471 604871 794921 795915 801896 757909 759762 759884 771211 728308 770138 742714 759607 382581 408795 439475 451471 562965 480959 710928 47689 425973 820678 452350 488955 584334 695107 710246 758550 811486 811745 429298 824533 828146 692473 651094 697216 710297 721936 644217 807410 794720 734011 733032 778490 750374 819773 536447 824180 547059 761714 828302 188176 814333 510045 506883 520674 553178 542207 711891 719873 680980 585162 596917 601905 587472 607522 625878 803498 807597 738576 771221 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.91%) |
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 47689 167756 181252 188176 318795 379604 382581 389629 390389 399659 400811 401465 405825 408795 409984 411081 415805 415928 425973 428209 429298 437310 439475 440490 446940 447251 448166 449095 451471 452350 456297 460622 468672 469590 475293 477576 480959 486588 488955 506883 510045 513721 516487 519505 520674 536447 541339 542207 547059 548320 553178 558431 562965 584334 585162 587471 587472 596917 601905 604871 604934 606018 607522 625878 644217 651094 680980 692473 695107 697216 709894 710246 710297 710928 711891 719873 720243 720833 721936 726795 728308 732721 733032 733545 734011 738576 742714 750374 757909 758550 759607 759762 759884 764250 768387 770138 771211 771221 778490 794720 794921 795915 797352 801896 803498 807410 807597 811486 811745 814333 815358 819773 820678 822590 824180 824533 828146 828494 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck natural milf"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс натуральная натуральные milf"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс натуральная натуральные milf"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.88%) |
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.