Query Metrics
7
Database Queries
7
Different statements
421.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.64 ms (50.47%) |
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 142993 162043 383501 393715 394646 402673 407816 409404 414358 425206 428113 443751 446275 450825 451866 454293 457332 462155 466493 467963 468860 469415 470487 470583 471426 472125 474695 474700 475080 478579 480841 482804 484696 485267 489447 499112 500480 501248 502819 506295 506301 514709 522887 524986 530826 530837 532665 533384 534143 535048 536290 537200 537763 538282 543771 559372 566553 571056 586555 599932 599941 599999 600275 600354 602615 603135 614407 617416 617418 629004 632694 634131 634487 639793 640531 641141 641930 641984 643376 645235 646175 646451 648861 649106 650175 650846 665455 666778 669391 671863 676092 676110 679733 680271 682514 704875 711891 712686 716882 723714 724293 731814 745245 746533 748239 773974 775140 775850 775971 784308 799362 801950 802121 806268 808808 815181 817354 820778 824130 827201 ] |
||||||||||||||||||||||||||||||
|
179.98 ms (42.72%) |
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 142993 162043 383501 393715 394646 402673 407816 409404 414358 425206 428113 443751 446275 450825 451866 454293 457332 462155 466493 467963 468860 469415 470487 470583 471426 472125 474695 474700 475080 478579 480841 482804 484696 485267 489447 499112 500480 501248 502819 506295 506301 514709 522887 524986 530826 530837 532665 533384 534143 535048 536290 537200 537763 538282 543771 559372 566553 571056 586555 599932 599941 599999 600275 600354 602615 603135 614407 617416 617418 629004 632694 634131 634487 639793 640531 641141 641930 641984 643376 645235 646175 646451 648861 649106 650175 650846 665455 666778 669391 671863 676092 676110 679733 680271 682514 704875 711891 712686 716882 723714 724293 731814 745245 746533 748239 773974 775140 775850 775971 784308 799362 801950 802121 806268 808808 815181 817354 820778 824130 827201 ] |
||||||||||||||||||||||||||||||
|
22.41 ms (5.32%) |
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 801950 745245 425206 485267 454293 474695 484696 142993 501248 414358 559372 665455 669391 711891 666778 603135 614407 775140 799362 500480 480841 586555 470487 506295 671863 471426 383501 824130 827201 820778 482804 469415 682514 599999 775971 784308 806268 773974 466493 457332 470583 428113 446275 499112 475080 462155 522887 502819 409404 645235 731814 724293 450825 641930 571056 538282 712686 602615 808808 704875 402673 162043 746533 537763 514709 679733 680271 566553 407816 468860 649106 599932 639793 634487 641141 451866 472125 543771 748239 817354 489447 629004 536290 530837 676110 646451 634131 617418 599941 632694 474700 394646 478579 506301 533384 530826 443751 815181 534143 775850 723714 467963 535048 532665 537200 646175 650175 716882 648861 650846 676092 641984 600275 600354 643376 802121 617416 640531 524986 393715 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"групповуха со зрелой"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"группов секс зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.28 ms (0.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.