Query Metrics
7
Database Queries
7
Different statements
166.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.22 ms (83.62%) |
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 182213 182227 182766 384478 392422 395145 401642 402644 407398 409274 414048 429518 432936 447668 448065 449017 452823 452827 453997 457812 458359 462682 469176 470278 473963 486244 489309 502777 502780 510280 518595 525931 531261 533725 535622 537928 543898 545473 550707 559781 563549 565456 567600 569575 583574 585430 587506 598451 599861 601517 603391 606365 618567 623205 628459 628717 631301 639717 642002 652772 662065 675079 676014 676090 677773 678732 685819 692651 697579 700682 703574 707570 714211 720582 730075 736802 738511 739820 740472 740556 742303 742342 744227 744985 749237 749669 751405 751433 751434 752589 755945 765182 768785 769161 769163 770258 774877 776148 782351 783319 783671 784227 786662 790568 791441 791797 793053 796339 796767 798293 804432 810811 812125 812395 813597 813811 814429 814492 816816 824892 ] |
||||||||||||||||||||||||||||||
|
16.59 ms (9.96%) |
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 776148 783671 730075 791797 769163 770258 740472 742342 765182 768785 736802 744227 697579 774877 784227 525931 489309 182227 384478 182766 395145 402644 813597 813811 449017 535622 543898 545473 652772 703574 707570 714211 675079 692651 628717 598451 618567 603391 786662 782351 791441 796767 810811 755945 783319 804432 769161 742303 739820 749669 751405 751434 631301 790568 814429 531261 601517 470278 414048 462682 452823 518595 502777 569575 565456 550707 563549 585430 587506 628459 448065 510280 816816 407398 824892 814492 533725 583574 720582 662065 678732 685819 700682 559781 567600 606365 793053 798293 812125 796339 812395 740556 744985 752589 738511 749237 751433 401642 502780 182213 432936 447668 458359 537928 676090 676014 677773 599861 642002 623205 639717 473963 392422 429518 409274 452827 453997 457812 486244 469176 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.82%) |
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 182213 182227 182766 384478 392422 395145 401642 402644 407398 409274 414048 429518 432936 447668 448065 449017 452823 452827 453997 457812 458359 462682 469176 470278 473963 486244 489309 502777 502780 510280 518595 525931 531261 533725 535622 537928 543898 545473 550707 559781 563549 565456 567600 569575 583574 585430 587506 598451 599861 601517 603391 606365 618567 623205 628459 628717 631301 639717 642002 652772 662065 675079 676014 676090 677773 678732 685819 692651 697579 700682 703574 707570 714211 720582 730075 736802 738511 739820 740472 740556 742303 742342 744227 744985 749237 749669 751405 751433 751434 752589 755945 765182 768785 769161 769163 770258 774877 776148 782351 783319 783671 784227 786662 790568 791441 791797 793053 796339 796767 798293 804432 810811 812125 812395 813597 813811 814429 814492 816816 824892 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fucking dildo"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fucking дилд"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fucking дилд"
]
|
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.