Query Metrics
7
Database Queries
7
Different statements
185.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.37 ms (84.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 6597 391087 397248 417066 422504 427183 428250 431120 432678 445880 447767 452631 453910 462607 465516 467594 470170 470565 471998 472608 473992 480294 481548 482699 487880 493583 496165 502797 503166 505054 515950 518412 520211 521470 522165 522167 522180 526456 526504 527010 533481 533658 540541 541532 546763 548619 550294 558040 563407 566392 579106 581722 582297 586277 596941 603545 608204 613021 613375 619485 626154 630937 644288 659615 710286 714183 720078 720343 726483 726871 727828 730947 732312 733296 735908 737161 752566 753106 754208 755453 755460 755474 755847 758213 760653 760792 765666 768186 768386 770322 770784 770814 770833 770888 770916 770920 770923 770926 774607 775787 775981 782179 785093 789457 791296 794557 794817 799951 800384 800608 801934 802547 805597 805600 805602 805645 811500 812022 812834 823151 ] |
||||||||||||||||||||||||||||||
|
17.17 ms (9.25%) |
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 710286 720343 548619 566392 644288 608204 613021 596941 613375 775787 782179 791296 794557 805597 774607 775981 789457 800608 801934 812022 726871 735908 753106 755460 770814 770888 770916 770920 785093 800384 802547 805602 811500 727828 755453 760792 770833 770923 752566 754208 755847 758213 768186 770926 737161 726483 730947 760653 770322 770784 630937 720078 805600 397248 391087 447767 470170 473992 522167 526456 518412 527010 563407 794817 755474 805645 6597 765666 427183 452631 431120 422504 428250 432678 417066 823151 482699 472608 445880 462607 471998 487880 493583 453910 465516 470565 480294 481548 496165 522180 533658 502797 515950 522165 526504 503166 520211 533481 540541 505054 521470 467594 558040 579106 581722 541532 550294 659615 546763 582297 626154 586277 619485 768386 799951 733296 732312 603545 714183 812834 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (1.70%) |
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 6597 391087 397248 417066 422504 427183 428250 431120 432678 445880 447767 452631 453910 462607 465516 467594 470170 470565 471998 472608 473992 480294 481548 482699 487880 493583 496165 502797 503166 505054 515950 518412 520211 521470 522165 522167 522180 526456 526504 527010 533481 533658 540541 541532 546763 548619 550294 558040 563407 566392 579106 581722 582297 586277 596941 603545 608204 613021 613375 619485 626154 630937 644288 659615 710286 714183 720078 720343 726483 726871 727828 730947 732312 733296 735908 737161 752566 753106 754208 755453 755460 755474 755847 758213 760653 760792 765666 768186 768386 770322 770784 770814 770833 770888 770916 770920 770923 770926 774607 775787 775981 782179 785093 789457 791296 794557 794817 799951 800384 800608 801934 802547 805597 805600 805602 805645 811500 812022 812834 823151 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"condom in anal"
]
|
||||||||||||||||||||||||||||||
|
2.16 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"condom анал"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"condom анал"
]
|
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.