Query Metrics
7
Database Queries
7
Different statements
418.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.80 ms (51.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"трусик нижн бел teen"
]
|
||||||||||||||||||||||||||||||
|
179.40 ms (42.83%) |
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 6941 91458 134210 383328 388869 398881 400880 401296 408470 412519 412733 414334 417135 420730 420803 421189 425141 427779 433051 433584 433596 433696 433815 433920 436694 437320 437402 439240 439268 441566 443897 450015 451529 454149 457013 463460 467041 467953 473062 476093 478532 480329 486567 489326 496127 500620 506494 514960 515090 517843 523422 523976 524115 524461 527530 527538 529018 537945 539699 547593 552213 561696 564459 564603 565921 568302 573462 574360 574363 574810 576321 577018 577780 584229 587011 587118 592410 592632 592820 595857 596255 598503 600450 604373 606287 606652 607199 616910 624877 625598 643355 646000 655150 671816 673938 675204 679557 702142 704339 709756 717875 725675 728706 735202 735768 738266 741296 746378 757347 757938 767056 770612 770929 799420 805639 806857 812395 813624 814155 814423 ] |
||||||||||||||||||||||||||||||
|
15.56 ms (3.71%) |
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 436694 523422 671816 624877 606652 616910 433584 433920 486567 606287 134210 91458 400880 425141 427779 412733 414334 439240 441566 437320 463460 450015 539699 500620 529018 515090 467953 547593 564603 574360 577018 584229 564459 574363 552213 561696 568302 573462 574810 576321 655150 704339 565921 577780 592632 592410 598503 587118 595857 625598 420730 433051 467041 473062 433696 433815 439268 457013 476093 6941 412519 420803 421189 443897 388869 454149 478532 480329 408470 437402 514960 506494 524115 527538 489326 524461 517843 417135 451529 433596 398881 401296 757347 383328 587011 523976 537945 813624 814423 814155 496127 527530 646000 679557 709756 675204 702142 673938 717875 600450 607199 592820 596255 604373 643355 799420 806857 812395 738266 770929 805639 728706 741296 757938 746378 767056 725675 735768 770612 735202 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (0.72%) |
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 6941 91458 134210 383328 388869 398881 400880 401296 408470 412519 412733 414334 417135 420730 420803 421189 425141 427779 433051 433584 433596 433696 433815 433920 436694 437320 437402 439240 439268 441566 443897 450015 451529 454149 457013 463460 467041 467953 473062 476093 478532 480329 486567 489326 496127 500620 506494 514960 515090 517843 523422 523976 524115 524461 527530 527538 529018 537945 539699 547593 552213 561696 564459 564603 565921 568302 573462 574360 574363 574810 576321 577018 577780 584229 587011 587118 592410 592632 592820 595857 596255 598503 600450 604373 606287 606652 607199 616910 624877 625598 643355 646000 655150 671816 673938 675204 679557 702142 704339 709756 717875 725675 728706 735202 735768 738266 741296 746378 757347 757938 767056 770612 770929 799420 805639 806857 812395 813624 814155 814423 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"panties teen"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"трусик нижн бел 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.