Query Metrics
7
Database Queries
7
Different statements
201.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.07 ms (87.04%) |
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 399541 411534 417553 420303 474475 478770 480998 509659 512841 542101 542238 544026 544036 546418 547979 552378 555403 555451 558590 567978 568244 568755 571787 572881 579997 583523 595438 598308 599814 615950 616846 617573 618071 623115 626398 628570 629474 629639 633108 635825 636765 639850 647030 651768 658931 666058 666982 668651 668686 671490 675561 677250 681513 682308 691558 693084 694401 696246 696960 699304 700947 703235 703927 705769 706786 708730 715293 716125 718029 722237 746197 748773 753700 753744 764782 765090 768916 769464 774872 777242 782749 782867 783029 783375 783602 783651 784469 785654 787172 788659 790283 791223 792237 792931 793061 795411 796397 797083 798419 800096 801806 803150 807212 810398 810904 810927 811106 813895 814097 814177 818700 819273 819761 825478 825991 826461 826495 826611 ] |
||||||||||||||||||||||||||||||
|
14.18 ms (7.05%) |
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 811106 753744 748773 703235 787172 810398 512841 558590 722237 658931 681513 616846 595438 618071 783602 791223 800096 783029 783375 783651 797083 810904 810927 746197 790283 793061 796397 768916 769464 753700 765090 764782 803150 807212 474475 399541 411534 420303 417553 814097 814177 826611 826495 818700 819273 825991 813895 819761 824734 825478 826461 480998 532226 509659 478770 544036 546418 567978 571787 572881 579997 544026 555403 555451 568244 568755 542101 542238 547979 552378 583523 666058 682308 694401 699304 700947 715293 716125 718029 666982 668686 671490 677250 696246 696960 703927 705769 706786 708730 647030 651768 668651 675561 691558 693084 615950 599814 623115 626398 633108 639850 598308 617573 635825 636765 628570 629474 629639 774872 777242 782749 782867 784469 785654 788659 792237 792931 795411 798419 801806 ] |
||||||||||||||||||||||||||||||
|
4.28 ms (2.13%) |
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 399541 411534 417553 420303 474475 478770 480998 509659 512841 542101 542238 544026 544036 546418 547979 552378 555403 555451 558590 567978 568244 568755 571787 572881 579997 583523 595438 598308 599814 615950 616846 617573 618071 623115 626398 628570 629474 629639 633108 635825 636765 639850 647030 651768 658931 666058 666982 668651 668686 671490 675561 677250 681513 682308 691558 693084 694401 696246 696960 699304 700947 703235 703927 705769 706786 708730 715293 716125 718029 722237 746197 748773 753700 753744 764782 765090 768916 769464 774872 777242 782749 782867 783029 783375 783602 783651 784469 785654 787172 788659 790283 791223 792237 792931 793061 795411 796397 797083 798419 800096 801806 803150 807212 810398 810904 810927 811106 813895 814097 814177 818700 819273 819761 825478 825991 826461 826495 826611 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation and orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мастурбац orgasm"
]
|
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.