Query Metrics
7
Database Queries
7
Different statements
179.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.97 ms (86.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 18 2332 7703 21545 83894 142735 162863 177285 210349 219957 279273 337234 367863 382419 382756 383100 383529 392890 395526 396597 399021 400467 400967 401477 402689 403076 407681 413109 420001 420023 483998 533191 533601 534751 553841 600311 616209 628297 635138 640602 640877 642659 668401 670111 677133 681134 682534 686035 688567 704887 708095 719276 723731 732144 732562 732953 735404 741290 747762 750074 753612 755463 755466 758634 759580 760668 765190 768552 771002 771368 771557 772401 772551 772585 772892 775362 779467 779563 779616 779829 781075 781363 781438 781444 786510 790855 791103 793412 795513 798235 798593 799411 799436 801839 801892 802549 804477 805015 805072 805148 805264 808815 814762 816801 816802 817443 817929 818333 818902 820872 821039 822388 824308 824491 827832 827833 827954 828407 ] |
||||||||||||||||||||||||||||||
|
14.39 ms (8.03%) |
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 805148 772892 798235 801892 741290 772585 753612 771557 640602 719276 790855 802549 395526 396597 382756 337234 791103 142735 401477 403076 779467 799411 210349 219957 400967 407681 21545 399021 400467 18 383100 177285 420023 747762 781444 616209 820872 628297 413109 402689 2332 827954 483998 704887 640877 779829 781438 781075 793412 799436 771368 765190 821039 827832 827833 775362 779276 798593 781363 805072 772401 732144 771846 772551 808815 383529 392890 420001 818902 83894 708095 533601 686035 668401 786510 805015 759580 755466 635138 804477 779563 382419 677133 670111 688567 642659 732953 801839 600311 816801 816802 822388 814762 824308 533191 534751 553841 795513 760668 771002 805264 750074 755463 779616 162863 824491 723731 735404 7703 279273 818333 817443 681134 732562 828407 817929 367863 682534 768552 758634 ] |
||||||||||||||||||||||||||||||
|
3.55 ms (1.98%) |
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 18 2332 7703 21545 83894 142735 162863 177285 210349 219957 279273 337234 367863 382419 382756 383100 383529 392890 395526 396597 399021 400467 400967 401477 402689 403076 407681 413109 420001 420023 483998 533191 533601 534751 553841 600311 616209 628297 635138 640602 640877 642659 668401 670111 677133 681134 682534 686035 688567 704887 708095 719276 723731 732144 732562 732953 735404 741290 747762 750074 753612 755463 755466 758634 759580 760668 765190 768552 771002 771368 771557 772401 772551 772585 772892 775362 779467 779563 779616 779829 781075 781363 781438 781444 786510 790855 791103 793412 795513 798235 798593 799411 799436 801839 801892 802549 804477 805015 805072 805148 805264 808815 814762 816801 816802 817443 817929 818333 818902 820872 821039 822388 824308 824491 827832 827833 827954 828407 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beauty blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"beauty минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"beauty минет оральн секс"
]
|
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.