Query Metrics
7
Database Queries
7
Different statements
148.13 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.48 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.71 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"piss big tits"
]
|
||||||||||||||||||||||||||||||
| 3 | 11.34 ms |
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 750538 647635 651599 626760 541844 562067 585331 608541 566729 820779 542583 567453 696203 597266 601517 633478 640762 666549 808579 632694 634773 680200 591487 542580 544366 748957 580264 625696 546048 545982 678144 600332 600340 545437 589240 647837 639767 630522 600206 642041 800588 619571 702168 635224 647994 676623 642018 600995 541888 556323 514240 633780 601655 676022 559111 711283 666535 647993 676641 600171 632649 642025 637086 586587 820759 640793 601583 674994 675008 641978 627808 541854 548226 630635 632595 600218 601856 545469 540572 675001 599922 632585 600021 539319 600252 600257 633435 598105 642766 ] |
||||||||||||||||||||||||||||||
| 4 | 2.44 ms |
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 514240 539319 540572 541844 541854 541888 542580 542583 544366 545437 545469 545982 546048 548226 556323 559111 562067 566729 567453 580264 585331 586587 589240 591487 597266 598105 599922 600021 600171 600206 600218 600252 600257 600332 600340 600995 601517 601583 601655 601856 608541 619571 625696 626760 627808 630522 630635 632585 632595 632649 632694 633435 633478 633780 634773 635224 637086 639767 640762 640793 641978 642018 642025 642041 642766 647635 647837 647993 647994 651599 666535 666549 674994 675001 675008 676022 676623 676641 678144 680200 696203 702168 711283 748957 750538 800588 808579 820759 820779 ] |
||||||||||||||||||||||||||||||
| 5 | 128.39 ms |
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 514240 539319 540572 541844 541854 541888 542580 542583 544366 545437 545469 545982 546048 548226 556323 559111 562067 566729 567453 580264 585331 586587 589240 591487 597266 598105 599922 600021 600171 600206 600218 600252 600257 600332 600340 600995 601517 601583 601655 601856 608541 619571 625696 626760 627808 630522 630635 632585 632595 632649 632694 633435 633478 633780 634773 635224 637086 639767 640762 640793 641978 642018 642025 642041 642766 647635 647837 647993 647994 651599 666535 666549 674994 675001 675008 676022 676623 676641 678144 680200 696203 702168 711283 748957 750538 800588 808579 820759 820779 ] |
||||||||||||||||||||||||||||||
| 6 | 1.56 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"писсинг большие сиськ"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.21 ms |
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.