Query Metrics
7
Database Queries
7
Different statements
163.17 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.98 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.96 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"squirt public"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.56 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 669907 594875 814010 560546 528384 580035 437864 417482 527198 502324 587506 826512 579769 708076 556825 739350 603286 820652 678713 491790 494233 534312 418363 793623 806955 494279 413826 562926 621761 810133 770242 653730 788366 813900 566987 588719 776082 457803 519762 473284 794015 546048 491489 444853 430700 793400 613797 611469 653720 750739 739556 499829 552577 455694 465097 479920 482780 555967 523212 573212 510779 555485 814434 734154 672418 791505 572259 495459 451254 566100 592756 628164 826233 427174 814931 826663 818456 469042 527931 447004 817885 460857 556001 617021 721970 584461 632304 503026 516723 599803 ] |
||||||||||||||||||||||||||||||
| 4 | 2.61 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 413826 417482 418363 427174 430700 437864 444853 447004 451254 455694 457803 460857 465097 469042 473284 479920 482780 491489 491790 494233 494279 495459 499829 502324 503026 510779 516723 519762 523212 527198 527931 528384 534312 546048 552577 555485 555967 556001 556825 560546 562926 566100 566987 572259 573212 579769 580035 584461 587506 592756 594875 599803 603286 611469 613797 617021 621761 628164 632304 653720 653730 669907 672418 678713 708076 721970 734154 739350 739556 750739 770242 776082 788366 791505 793400 793623 794015 806955 810133 813900 814010 814434 814931 817885 818456 820652 826233 826512 826663 ] |
||||||||||||||||||||||||||||||
| 5 | 135.73 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 413826 417482 418363 427174 430700 437864 444853 447004 451254 455694 457803 460857 465097 469042 473284 479920 482780 491489 491790 494233 494279 495459 499829 502324 503026 510779 516723 519762 523212 527198 527931 528384 534312 546048 552577 555485 555967 556001 556825 560546 562926 566100 566987 572259 573212 579769 580035 584461 587506 592756 594875 599803 603286 611469 613797 617021 621761 628164 632304 653720 653730 669907 672418 678713 708076 721970 734154 739350 739556 750739 770242 776082 788366 791505 793400 793623 794015 806955 810133 813900 814010 814434 814931 817885 818456 820652 826233 826512 826663 ] |
||||||||||||||||||||||||||||||
| 6 | 3.40 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сквирт оргазм на улиц"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.93 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.