Query Metrics
7
Database Queries
7
Different statements
125.09 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.40 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.18 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"prolapse fisting anal"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.20 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 670372 660382 669035 669057 591003 799693 805144 497030 609890 625783 669058 590255 524678 534777 751582 456219 669075 670368 786906 745126 751546 763739 462840 547462 666528 540032 564227 669362 669018 660416 661008 630420 758779 709128 411285 530026 455080 449173 547478 512994 520713 651674 513790 545369 559377 602024 609885 766335 456226 635171 512939 609892 564387 669079 660375 669361 642022 457541 524677 512928 432299 825864 483745 530375 811296 749087 516508 584301 574388 805146 532791 614743 530491 530630 530376 569927 532739 430520 512938 640751 599835 533563 718782 602249 533557 ] |
||||||||||||||||||||||||||||||
| 4 | 2.63 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 411285 430520 432299 449173 455080 456219 456226 457541 462840 483745 497030 512928 512938 512939 512994 513790 516508 520713 524678 530026 530375 530376 530491 530630 532739 532791 533557 533563 534777 540032 545369 547462 547478 559377 564227 564387 569927 574388 584301 590255 591003 599835 602024 602249 609885 609890 609892 614743 625783 630420 635171 640751 642022 651674 660375 660382 660416 661008 666528 669018 669035 669057 669058 669075 669079 669361 669362 670368 670372 709128 718782 745126 749087 751546 751582 758779 763739 766335 786906 799693 805144 805146 811296 825864 ] |
||||||||||||||||||||||||||||||
| 5 | 100.30 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 411285 430520 432299 449173 455080 456219 456226 457541 462840 483745 497030 512928 512938 512939 512994 513790 516508 520713 524678 530026 530375 530376 530491 530630 532739 532791 533557 533563 534777 540032 545369 547462 547478 559377 564227 564387 569927 574388 584301 590255 591003 599835 602024 602249 609885 609890 609892 614743 625783 630420 635171 640751 642022 651674 660375 660382 660416 661008 666528 669018 669035 669057 669058 669075 669079 669361 669362 670368 670372 709128 718782 745126 749087 751546 751582 758779 763739 766335 786906 799693 805144 805146 811296 825864 ] |
||||||||||||||||||||||||||||||
| 6 | 1.74 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"prolapse фистинг анал"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.63 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"prolapse фистинг анал"
]
|
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.