Query Metrics
7
Database Queries
7
Different statements
132.81 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.20 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.89 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"весит грудь"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.16 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 447045 494231 649893 486198 543860 490533 537208 495647 529846 533471 545382 545615 562373 577409 680183 556014 593373 634212 630193 633114 466021 468586 505504 420541 565153 578782 507944 482953 445802 523860 546201 400995 400808 446059 510887 511404 484558 494962 489950 653870 557021 457160 526853 530832 565172 613463 586713 528096 468010 632006 612751 579188 532747 541661 622398 602939 547612 677784 564136 612434 520672 601324 513882 519171 537210 530024 531187 530382 543844 555789 580669 628126 618793 469595 550315 633423 515544 596054 649080 678522 642766 530762 533557 632563 ] |
||||||||||||||||||||||||||||||
| 4 | 2.33 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 400808 400995 420541 445802 446059 447045 457160 466021 468010 468586 469595 482953 484558 486198 489950 490533 494231 494962 495647 505504 507944 510887 511404 513882 515544 519171 520672 523860 526853 528096 529846 530024 530382 530762 530832 531187 532747 533471 533557 537208 537210 541661 543844 543860 545382 545615 546201 547612 550315 555789 556014 557021 562373 564136 565153 565172 577409 578782 579188 580669 586713 593373 596054 601324 602939 612434 612751 613463 618793 622398 628126 630193 632006 632563 633114 633423 634212 642766 649080 649893 653870 677784 678522 680183 ] |
||||||||||||||||||||||||||||||
| 5 | 106.07 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 400808 400995 420541 445802 446059 447045 457160 466021 468010 468586 469595 482953 484558 486198 489950 490533 494231 494962 495647 505504 507944 510887 511404 513882 515544 519171 520672 523860 526853 528096 529846 530024 530382 530762 530832 531187 532747 533471 533557 537208 537210 541661 543844 543860 545382 545615 546201 547612 550315 555789 556014 557021 562373 564136 565153 565172 577409 578782 579188 580669 586713 593373 596054 601324 602939 612434 612751 613463 618793 622398 628126 630193 632006 632563 633114 633423 634212 642766 649080 649893 653870 677784 678522 680183 ] |
||||||||||||||||||||||||||||||
| 6 | 2.27 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вес сиськ"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.89 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.