Query Metrics
7
Database Queries
7
Different statements
397.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.20 ms (53.61%) |
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 387680 397567 399405 401404 407108 412725 413398 415855 416539 419130 424341 424884 425321 426259 432692 433082 433395 440016 441073 441131 442674 444018 445975 447160 453165 456226 456229 466477 469567 473145 476184 476934 480406 487191 495331 500815 510783 511893 512508 513486 517405 517816 519368 520910 521792 524147 525050 529583 532854 541228 541322 542203 542701 542723 543085 544238 544852 546061 551114 555307 560945 566843 571003 574908 577644 587303 594584 603362 606081 610061 614957 635251 640785 657505 669067 677726 679660 682739 705362 706588 708923 709693 715879 718772 720738 724240 726322 727545 727823 731327 731862 734331 736516 756830 757438 758801 767054 772406 773912 777533 778724 780665 781987 782453 782789 785018 789878 790865 795867 797447 799354 800418 802395 806101 811476 811643 817235 822309 824937 826087 ] |
||||||||||||||||||||||||||||||
|
162.35 ms (40.82%) |
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 387680 397567 399405 401404 407108 412725 413398 415855 416539 419130 424341 424884 425321 426259 432692 433082 433395 440016 441073 441131 442674 444018 445975 447160 453165 456226 456229 466477 469567 473145 476184 476934 480406 487191 495331 500815 510783 511893 512508 513486 517405 517816 519368 520910 521792 524147 525050 529583 532854 541228 541322 542203 542701 542723 543085 544238 544852 546061 551114 555307 560945 566843 571003 574908 577644 587303 594584 603362 606081 610061 614957 635251 640785 657505 669067 677726 679660 682739 705362 706588 708923 709693 715879 718772 720738 724240 726322 727545 727823 731327 731862 734331 736516 756830 757438 758801 767054 772406 773912 777533 778724 780665 781987 782453 782789 785018 789878 790865 795867 797447 799354 800418 802395 806101 811476 811643 817235 822309 824937 826087 ] |
||||||||||||||||||||||||||||||
|
14.86 ms (3.74%) |
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 773912 724240 731327 756830 780665 799354 441131 447160 603362 419130 456226 456229 519368 520910 487191 424341 532854 476934 525050 529583 720738 614957 517816 432692 473145 511893 669067 566843 709693 413398 442674 453165 469567 513486 510783 387680 826087 817235 824937 679660 715879 610061 802395 734331 731862 772406 781987 551114 795867 806101 415855 426259 440016 560945 635251 521792 789878 412725 727823 757438 444018 797447 433082 524147 544852 577644 512508 822309 544238 677726 706588 682739 800418 727545 736516 425321 424884 466477 476184 574908 594584 416539 480406 517405 397567 433395 571003 777533 401404 495331 542203 541228 758801 441073 500815 541322 542701 718772 657505 708923 606081 782789 640785 811643 445975 555307 811476 767054 726322 790865 399405 407108 542723 543085 546061 705362 587303 778724 782453 785018 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck ass hole"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс жоп дырк"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс жоп дырк"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.38%) |
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.