Query Metrics
7
Database Queries
7
Different statements
169.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.27 ms (84.17%) |
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 239808 391072 392691 395651 396245 397102 399551 400307 400461 400698 403258 408429 411125 415978 416153 416668 416689 416701 417940 418649 421072 421443 422929 423464 427246 432685 453793 456215 463266 465237 466966 474626 479759 485085 485228 492794 496076 504303 504393 504479 511836 515744 516695 525058 525432 527049 530576 531767 534127 537774 543659 544206 544368 564066 571215 571219 572176 574606 574911 584295 597820 603285 604051 605325 605326 605851 606102 608425 608765 609878 611299 617128 617660 619367 656575 661652 671396 672766 672767 692001 694028 694131 696218 696280 723927 728675 729256 733138 736208 739913 747687 748541 748686 750410 753971 757182 757906 759581 761773 763522 766852 767207 772635 774250 777551 780363 781568 788198 790394 791521 796532 804373 807301 814265 816595 817378 823808 825133 826728 827942 ] |
||||||||||||||||||||||||||||||
|
16.12 ms (9.53%) |
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 827942 605326 759581 415978 525058 400698 791521 728675 408429 617660 574911 584295 617128 597820 391072 696280 544368 748541 423464 527049 516695 604051 826728 825133 534127 780363 739913 753971 757182 777551 781568 788198 392691 416689 574606 400461 422929 530576 807301 418649 814265 456215 572176 656575 694028 564066 606102 611299 608425 605851 608765 723927 747687 733138 748686 763522 466966 474626 432685 492794 485085 239808 395651 396245 504479 571215 672767 671396 672766 571219 609878 605325 790394 750410 729256 399551 504393 603285 427246 694131 692001 543659 485228 661652 397102 816595 817378 796532 766852 411125 403258 421443 453793 416701 479759 416668 823808 416153 421072 511836 544206 696218 619367 804373 757906 417940 465237 463266 504303 515744 496076 531767 537774 761773 736208 774250 767207 772635 400307 525432 ] |
||||||||||||||||||||||||||||||
|
3.60 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 239808 391072 392691 395651 396245 397102 399551 400307 400461 400698 403258 408429 411125 415978 416153 416668 416689 416701 417940 418649 421072 421443 422929 423464 427246 432685 453793 456215 463266 465237 466966 474626 479759 485085 485228 492794 496076 504303 504393 504479 511836 515744 516695 525058 525432 527049 530576 531767 534127 537774 543659 544206 544368 564066 571215 571219 572176 574606 574911 584295 597820 603285 604051 605325 605326 605851 606102 608425 608765 609878 611299 617128 617660 619367 656575 661652 671396 672766 672767 692001 694028 694131 696218 696280 723927 728675 729256 733138 736208 739913 747687 748541 748686 750410 753971 757182 757906 759581 761773 763522 766852 767207 772635 774250 777551 780363 781568 788198 790394 791521 796532 804373 807301 814265 816595 817378 823808 825133 826728 827942 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young teen amateur"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young teen любительск"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young teen любительск"
]
|
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.