Query Metrics
7
Database Queries
7
Different statements
128.21 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.08 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.50 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge busty"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.55 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 465006 472578 647935 690323 587162 607236 610343 401465 413087 449870 465079 454282 459879 465553 526799 487547 397481 414200 415919 415547 424366 815313 464994 501682 531191 531304 518191 528845 577535 553296 581602 584635 615839 794214 439445 453132 413584 479657 454562 456766 417473 446019 529187 431393 432831 471881 510199 536562 536489 645952 446909 451804 409035 448926 523012 447959 473869 573941 708441 629357 585701 428758 471088 527942 526814 416166 454954 446738 579647 678117 674988 419123 477757 527767 414771 543579 558991 675010 609845 530777 561478 409001 512527 ] |
||||||||||||||||||||||||||||||
| 4 | 3.08 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 397481 401465 409001 409035 413087 413584 414200 414771 415547 415919 416166 417473 419123 424366 428758 431393 432831 439445 446019 446738 446909 447959 448926 449870 451804 453132 454282 454562 454954 456766 459879 464994 465006 465079 465553 471088 471881 472578 473869 477757 479657 487547 501682 510199 512527 518191 523012 526799 526814 527767 527942 528845 529187 530777 531191 531304 536489 536562 543579 553296 558991 561478 573941 577535 579647 581602 584635 585701 587162 607236 609845 610343 615839 629357 645952 647935 674988 675010 678117 690323 708441 794214 815313 ] |
||||||||||||||||||||||||||||||
| 5 | 100.84 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 397481 401465 409001 409035 413087 413584 414200 414771 415547 415919 416166 417473 419123 424366 428758 431393 432831 439445 446019 446738 446909 447959 448926 449870 451804 453132 454282 454562 454954 456766 459879 464994 465006 465079 465553 471088 471881 472578 473869 477757 479657 487547 501682 510199 512527 518191 523012 526799 526814 527767 527942 528845 529187 530777 531191 531304 536489 536562 543579 553296 558991 561478 573941 577535 579647 581602 584635 585701 587162 607236 609845 610343 615839 629357 645952 647935 674988 675010 678117 690323 708441 794214 815313 ] |
||||||||||||||||||||||||||||||
| 6 | 2.07 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные busty"
]
|
||||||||||||||||||||||||||||||
| 7 | 3.08 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"огромные busty"
]
|
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.