Query Metrics
7
Database Queries
7
Different statements
191.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.52 ms (88.88%) |
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 241269 331382 478767 479744 482947 484096 498642 507861 518974 521969 542479 545002 553822 557482 558533 559467 560545 566238 572662 578237 585514 617657 625503 625937 627624 628020 635649 639895 640166 651243 651355 652310 660022 660738 664696 668087 670741 673908 685434 691737 695780 697215 707008 707214 707512 708915 712688 712704 714218 719245 719453 722253 724078 725273 727695 732616 732840 732850 732855 733742 734358 735933 735999 736239 736889 740763 742771 744199 747005 748855 752490 752752 753304 758217 759612 759871 761727 762278 764245 768394 768570 769559 771784 775543 776109 776253 778839 778905 779046 779841 780726 782122 784160 784218 785082 787249 787990 790050 790251 790617 790942 791083 793365 793966 794338 797194 801961 803225 805665 805788 806240 810904 812178 814061 817342 818926 819868 824803 826941 ] |
||||||||||||||||||||||||||||||
|
11.33 ms (5.91%) |
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 752490 759612 727695 761727 559467 542479 482947 478767 707214 518974 735999 744199 707008 803225 652310 660738 707512 651355 685434 712688 635649 640166 627624 733742 736889 331382 585514 784160 732840 734358 732855 764245 708915 794338 625503 826109 724078 736239 735933 722253 787990 790251 787249 791083 793365 747005 771784 790617 479744 560545 651243 797194 660022 625937 714218 753304 241269 819868 817342 712704 790942 779841 752752 784218 793966 805788 732616 759871 824803 826941 498642 553822 812178 775543 805665 806240 742771 768570 521969 814061 664696 545002 572662 639895 780726 790050 776109 778839 778905 810904 725273 782122 785082 762278 748855 768394 758217 507861 566238 670741 673908 776253 740763 769559 617657 719453 818926 779046 732850 484096 578237 628020 801961 719245 557482 558533 668087 691737 695780 697215 ] |
||||||||||||||||||||||||||||||
|
3.43 ms (1.79%) |
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 241269 331382 478767 479744 482947 484096 498642 507861 518974 521969 542479 545002 553822 557482 558533 559467 560545 566238 572662 578237 585514 617657 625503 625937 627624 628020 635649 639895 640166 651243 651355 652310 660022 660738 664696 668087 670741 673908 685434 691737 695780 697215 707008 707214 707512 708915 712688 712704 714218 719245 719453 722253 724078 725273 727695 732616 732840 732850 732855 733742 734358 735933 735999 736239 736889 740763 742771 744199 747005 748855 752490 752752 753304 758217 759612 759871 761727 762278 764245 768394 768570 769559 771784 775543 776109 776253 778839 778905 779046 779841 780726 782122 784160 784218 785082 787249 787990 790050 790251 790617 790942 791083 793365 793966 794338 797194 801961 803225 805665 805788 806240 810904 812178 814061 817342 818926 819868 824803 826941 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"home amateurs sex"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"home любительск секс"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"home любительск секс"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.68%) |
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.