Query Metrics
7
Database Queries
7
Different statements
151.72 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.75 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.85 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal teen student"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.66 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 693278 776248 392986 678954 641886 604217 751120 419655 580631 701508 598958 384745 428385 464582 478168 404753 434067 684190 393659 395756 491040 659013 628865 776126 640521 436690 654914 723927 620749 475189 454566 478779 497873 429006 397129 614987 466755 482194 458494 492994 395640 587545 450861 469745 383748 398440 720871 410093 467696 403249 447350 421172 497338 401344 551245 749693 396249 508003 574696 459805 601475 455430 401305 428631 660060 540270 541110 551246 637751 785572 461148 567685 659215 596437 473180 523873 491644 528448 744290 395648 517869 652893 ] |
||||||||||||||||||||||||||||||
| 4 | 2.55 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 383748 384745 392986 393659 395640 395648 395756 396249 397129 398440 401305 401344 403249 404753 410093 419655 421172 428385 428631 429006 434067 436690 447350 450861 454566 455430 458494 459805 461148 464582 466755 467696 469745 473180 475189 478168 478779 482194 491040 491644 492994 497338 497873 508003 517869 523873 528448 540270 541110 551245 551246 567685 574696 580631 587545 596437 598958 601475 604217 614987 620749 628865 637751 640521 641886 652893 654914 659013 659215 660060 678954 684190 693278 701508 720871 723927 744290 749693 751120 776126 776248 785572 ] |
||||||||||||||||||||||||||||||
| 5 | 126.43 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 383748 384745 392986 393659 395640 395648 395756 396249 397129 398440 401305 401344 403249 404753 410093 419655 421172 428385 428631 429006 434067 436690 447350 450861 454566 455430 458494 459805 461148 464582 466755 467696 469745 473180 475189 478168 478779 482194 491040 491644 492994 497338 497873 508003 517869 523873 528448 540270 541110 551245 551246 567685 574696 580631 587545 596437 598958 601475 604217 614987 620749 628865 637751 640521 641886 652893 654914 659013 659215 660060 678954 684190 693278 701508 720871 723927 744290 749693 751120 776126 776248 785572 ] |
||||||||||||||||||||||||||||||
| 6 | 1.81 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал teen student"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.67 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал teen student"
]
|
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.