Query Metrics
7
Database Queries
7
Different statements
128.30 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.96 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.26 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"спит рядом трахает"
]
|
||||||||||||||||||||||||||||||
| 3 | 19.40 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 548593 551798 681445 457682 475866 507156 524044 550485 578856 579221 518388 516432 392775 506127 418867 421323 523911 424995 454341 461366 478875 776788 517369 509393 500536 465767 484343 489301 502241 518961 477327 527669 464699 623933 447499 567211 518851 563166 476339 573742 563872 432819 490015 585318 620100 583457 552305 605952 609252 486536 552319 468834 590427 401956 550336 446299 467311 603759 520407 471448 504768 512927 528176 597580 534837 520445 529485 620024 608737 619107 609225 491208 413934 464549 520021 553485 421030 442434 544495 577403 504765 682252 550662 566587 554784 613359 512952 ] |
||||||||||||||||||||||||||||||
| 4 | 3.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 392775 401956 413934 418867 421030 421323 424995 432819 442434 446299 447499 454341 457682 461366 464549 464699 465767 467311 468834 471448 475866 476339 477327 478875 484343 486536 489301 490015 491208 500536 502241 504765 504768 506127 507156 509393 512927 512952 516432 517369 518388 518851 518961 520021 520407 520445 523911 524044 527669 528176 529485 534837 544495 548593 550336 550485 550662 551798 552305 552319 553485 554784 563166 563872 566587 567211 573742 577403 578856 579221 583457 585318 590427 597580 603759 605952 608737 609225 609252 613359 619107 620024 620100 623933 681445 682252 776788 ] |
||||||||||||||||||||||||||||||
| 5 | 97.67 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 392775 401956 413934 418867 421030 421323 424995 432819 442434 446299 447499 454341 457682 461366 464549 464699 465767 467311 468834 471448 475866 476339 477327 478875 484343 486536 489301 490015 491208 500536 502241 504765 504768 506127 507156 509393 512927 512952 516432 517369 518388 518851 518961 520021 520407 520445 523911 524044 527669 528176 529485 534837 544495 548593 550336 550485 550662 551798 552305 552319 553485 554784 563166 563872 566587 567211 573742 577403 578856 579221 583457 585318 590427 597580 603759 605952 608737 609225 609252 613359 619107 620024 620100 623933 681445 682252 776788 ] |
||||||||||||||||||||||||||||||
| 6 | 1.92 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спящ ряд секс"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.76 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.