Query Metrics
7
Database Queries
7
Different statements
199.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.47 ms (83.34%) |
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 33459 405050 414337 425206 445737 447500 451256 467608 506328 522858 523856 525657 527428 530010 530381 530624 531109 531116 531225 531232 531420 532679 532789 532792 533697 534627 536339 537885 537908 540404 540573 542566 542590 543615 543918 544797 544803 544823 545424 545851 550196 550307 554462 565247 565253 565255 567304 568177 576690 577331 582549 583640 583675 590411 591680 596462 597266 598057 599902 599945 600194 600334 600365 601576 604369 604517 605338 606501 606578 614401 617412 624179 628086 629899 631195 632611 632623 632673 632694 633816 634145 635275 636311 636321 636598 637022 637031 637074 637143 637416 639793 639802 640767 641130 641141 642038 647969 648499 648815 650762 651188 653447 674978 675000 676016 676107 678028 678067 678161 679728 680126 680186 681637 697001 716882 720938 731665 748244 748389 778359 ] |
||||||||||||||||||||||||||||||
|
23.35 ms (11.69%) |
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 748244 617412 629899 632611 632623 641130 697001 720938 405050 506328 576690 545851 590411 636598 467608 681637 591680 604517 531420 543918 675000 635275 540573 532789 577331 676016 680186 451256 33459 425206 522858 525657 530010 530381 530624 531225 531232 534627 537885 537908 532792 536339 531109 531116 532679 527428 533697 540404 544823 554462 568177 542590 583675 542566 543615 544803 565255 582549 647969 674978 678067 678161 679728 648499 650762 653447 678028 716882 648815 651188 676107 680126 544797 545424 550196 550307 565247 565253 567304 583640 599945 601576 631195 632673 634145 636311 596462 597266 598057 606501 624179 636321 637143 637416 639793 639802 600365 628086 637031 599902 600194 600334 604369 640767 641141 731665 748389 605338 606578 614401 632694 633816 637022 642038 778359 414337 447500 523856 637074 445737 ] |
||||||||||||||||||||||||||||||
|
3.34 ms (1.67%) |
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 33459 405050 414337 425206 445737 447500 451256 467608 506328 522858 523856 525657 527428 530010 530381 530624 531109 531116 531225 531232 531420 532679 532789 532792 533697 534627 536339 537885 537908 540404 540573 542566 542590 543615 543918 544797 544803 544823 545424 545851 550196 550307 554462 565247 565253 565255 567304 568177 576690 577331 582549 583640 583675 590411 591680 596462 597266 598057 599902 599945 600194 600334 600365 601576 604369 604517 605338 606501 606578 614401 617412 624179 628086 629899 631195 632611 632623 632673 632694 633816 634145 635275 636311 636321 636598 637022 637031 637074 637143 637416 639793 639802 640767 641130 641141 642038 647969 648499 648815 650762 651188 653447 674978 675000 676016 676107 678028 678067 678161 679728 680126 680186 681637 697001 716882 720938 731665 748244 748389 778359 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чулк нижн бел gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stockings gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"чулк нижн бел gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.70%) |
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.