Query Metrics
7
Database Queries
7
Different statements
576.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.56 ms (36.49%) |
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 3561 7295 183074 389144 395145 400638 401126 409165 412330 420774 428700 432656 439532 440723 443246 444018 445041 447040 451252 454517 454688 465143 465670 466206 466235 466907 469139 470052 471764 479768 481926 484241 484626 485468 490918 493700 495481 499905 503861 505725 511375 511856 513986 517514 523884 526833 527570 531880 537894 540511 541836 541839 541850 547474 547476 550925 554526 554551 555045 555066 555771 561040 573175 596694 604925 609097 613326 623193 628698 632121 633111 633819 639717 639782 646200 660416 665893 667276 672946 680484 692711 695870 707556 711629 713505 726315 738827 740492 742323 742358 742409 748522 749219 751571 752644 758778 758787 759948 772578 775139 781663 782653 782806 788953 791916 794205 794647 796801 800508 804432 805366 806793 808168 809371 815210 818387 819237 823884 825751 826489 ] |
||||||||||||||||||||||||||||||
|
209.50 ms (36.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature жоп дилд"
]
|
||||||||||||||||||||||||||||||
|
131.19 ms (22.74%) |
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 3561 7295 183074 389144 395145 400638 401126 409165 412330 420774 428700 432656 439532 440723 443246 444018 445041 447040 451252 454517 454688 465143 465670 466206 466235 466907 469139 470052 471764 479768 481926 484241 484626 485468 490918 493700 495481 499905 503861 505725 511375 511856 513986 517514 523884 526833 527570 531880 537894 540511 541836 541839 541850 547474 547476 550925 554526 554551 555045 555066 555771 561040 573175 596694 604925 609097 613326 623193 628698 632121 633111 633819 639717 639782 646200 660416 665893 667276 672946 680484 692711 695870 707556 711629 713505 726315 738827 740492 742323 742358 742409 748522 749219 751571 752644 758778 758787 759948 772578 775139 781663 782653 782806 788953 791916 794205 794647 796801 800508 804432 805366 806793 808168 809371 815210 818387 819237 823884 825751 826489 ] |
||||||||||||||||||||||||||||||
|
18.58 ms (3.22%) |
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 7295 540511 672946 751571 826489 537894 633819 633111 639717 479768 823884 395145 409165 819237 527570 665893 646200 775139 794647 800508 772578 781663 804432 748522 742409 400638 428700 451252 541850 726315 738827 758787 632121 806793 440723 439532 526833 825751 490918 541839 443246 541836 680484 511375 471764 511856 547474 695870 660416 561040 788953 573175 609097 815210 470052 513986 469139 466907 466206 466235 484626 454517 555066 742358 791916 481926 505725 432656 499905 604925 517514 554526 389144 183074 493700 547476 550925 809371 412330 420774 818387 447040 454688 485468 503861 531880 554551 667276 707556 711629 692711 713505 555045 628698 596694 613326 623193 639782 782653 782806 796801 805366 759948 808168 740492 742323 749219 752644 758778 794205 465670 401126 465143 484241 495481 523884 444018 3561 445041 555771 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature жоп дилд"
]
|
||||||||||||||||||||||||||||||
|
2.39 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature ass dildo"
]
|
||||||||||||||||||||||||||||||
|
2.16 ms (0.37%) |
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.