Query Metrics
7
Database Queries
7
Different statements
404.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
370.19 ms (91.46%) |
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 97377 191485 282218 382912 398689 414301 416652 416677 416751 420358 422658 423428 428009 428353 428404 433232 433318 434874 440629 444526 448817 448821 448862 451533 454600 465354 465407 466801 471881 477210 478581 488698 490783 491256 495401 495786 497725 500100 500686 502770 507693 510061 510781 513149 514241 514892 517308 521426 523420 529969 532381 532467 536675 540241 542993 545152 545796 545838 547658 548253 549099 551057 567774 569122 572172 576895 576933 592335 603172 605333 605337 613515 619832 622645 629893 632059 633447 641623 644264 651630 651957 656175 682464 688369 691992 692378 693952 694010 694553 696594 699755 700281 700282 703364 710286 710933 710946 719651 720095 735768 740409 751760 752650 761573 761801 766772 772684 777173 778533 780784 784256 786506 786879 788119 799762 805039 805164 806058 806397 821195 ] |
||||||||||||||||||||||||||||||
|
25.01 ms (6.18%) |
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 488698 451533 97377 434874 433232 423428 448862 510061 548253 592335 478581 495786 613515 440629 549099 633447 398689 382912 477210 572172 428353 465354 540241 551057 651957 700282 692378 694553 719651 699755 545152 805164 778533 806397 766772 735768 761801 777173 784256 422658 466801 641623 282218 513149 523420 751760 536675 500686 632059 703364 629893 576895 688369 420358 433318 521426 191485 444526 454600 465407 507693 514892 497725 500100 529969 576933 619832 622645 605337 806058 761573 788119 780784 786506 428009 448817 448821 414301 547658 416677 416751 428404 471881 567774 495401 491256 514241 542993 517308 490783 691992 805039 710933 416652 821195 510781 532381 502770 532467 545796 545838 569122 656175 682464 693952 651630 694010 696594 700281 720095 710286 710946 644264 603172 786879 772684 799762 740409 752650 605333 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (0.59%) |
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 97377 191485 282218 382912 398689 414301 416652 416677 416751 420358 422658 423428 428009 428353 428404 433232 433318 434874 440629 444526 448817 448821 448862 451533 454600 465354 465407 466801 471881 477210 478581 488698 490783 491256 495401 495786 497725 500100 500686 502770 507693 510061 510781 513149 514241 514892 517308 521426 523420 529969 532381 532467 536675 540241 542993 545152 545796 545838 547658 548253 549099 551057 567774 569122 572172 576895 576933 592335 603172 605333 605337 613515 619832 622645 629893 632059 633447 641623 644264 651630 651957 656175 682464 688369 691992 692378 693952 694010 694553 696594 699755 700281 700282 703364 710286 710933 710946 719651 720095 735768 740409 751760 752650 761573 761801 766772 772684 777173 778533 780784 784256 786506 786879 788119 799762 805039 805164 806058 806397 821195 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"молодых в анал нарезкÐ…"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"молодые анал подборк"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.