Query Metrics
7
Database Queries
7
Different statements
150.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.32 ms (82.39%) |
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 24158 24218 34201 62251 191312 247538 359134 367800 382906 383002 383042 383888 385933 386217 386787 386870 390754 390981 392486 408351 410305 415023 418566 418954 425505 425508 429552 442100 444126 444129 445497 456796 463509 466205 466453 468157 468159 469727 471182 472010 473707 476788 477964 481656 481927 482483 484540 490397 491244 492630 495905 501342 504347 506833 517540 519754 523552 526234 528762 530346 536514 551963 552299 554888 563296 565736 566624 566627 568111 580313 585849 587625 607335 607444 624936 627344 635011 648112 660067 663286 664286 665257 668270 669452 669515 670698 672811 673668 675587 677148 715859 717079 717473 722368 723764 724639 733091 736392 740442 742696 744404 745749 748757 753050 757240 757241 769614 779498 793590 794872 795884 797175 797315 802244 804480 810092 811541 813818 814678 823989 ] |
||||||||||||||||||||||||||||||
|
15.46 ms (10.24%) |
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 418566 386870 677148 673668 795884 736392 744404 742696 802244 495905 491244 675587 477964 418954 757241 757240 669515 429552 669452 456796 469727 383042 392486 528762 665257 724639 733091 769614 390754 660067 587625 745749 823989 668270 670698 811541 717473 484540 247538 425505 517540 473707 551963 34201 672811 408351 779498 722368 482483 506833 383888 382906 390981 425508 444126 552299 471182 501342 504347 753050 359134 530346 24158 191312 481656 648112 664286 568111 523552 813818 481927 585849 794872 797175 797315 748757 793590 804480 810092 415023 444129 566624 466453 635011 814678 554888 563296 624936 740442 607444 383002 492630 536514 566627 565736 607335 627344 472010 468159 466205 445497 717079 723764 526234 367800 519754 386787 580313 663286 62251 410305 442100 463509 715859 476788 490397 468157 24218 385933 386217 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (2.20%) |
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 24158 24218 34201 62251 191312 247538 359134 367800 382906 383002 383042 383888 385933 386217 386787 386870 390754 390981 392486 408351 410305 415023 418566 418954 425505 425508 429552 442100 444126 444129 445497 456796 463509 466205 466453 468157 468159 469727 471182 472010 473707 476788 477964 481656 481927 482483 484540 490397 491244 492630 495905 501342 504347 506833 517540 519754 523552 526234 528762 530346 536514 551963 552299 554888 563296 565736 566624 566627 568111 580313 585849 587625 607335 607444 624936 627344 635011 648112 660067 663286 664286 665257 668270 669452 669515 670698 672811 673668 675587 677148 715859 717079 717473 722368 723764 724639 733091 736392 740442 742696 744404 745749 748757 753050 757240 757241 769614 779498 793590 794872 795884 797175 797315 802244 804480 810092 811541 813818 814678 823989 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в душе большие сиськи"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ван большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ван большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.21%) |
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.