Query Metrics
7
Database Queries
7
Different statements
146.98 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.73 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.75 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy anal brunette"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.32 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 555009 502043 538360 514820 517654 525393 559577 579389 662137 576623 621698 425523 488734 491392 541592 668549 713564 628327 631163 389208 396087 524992 529213 533982 484727 699574 445428 483978 566839 508518 574258 591354 401318 445471 514070 401071 420050 468835 601162 401919 396121 515964 639739 430404 466982 454802 487746 558788 639824 756395 498551 535460 423332 716078 404584 676117 405061 422618 517604 548556 566007 598552 622204 630063 436942 650380 526052 422192 417801 434310 540511 647948 445641 531804 405287 524773 446373 388059 641978 682531 623330 663537 577392 434376 626497 549225 ] |
||||||||||||||||||||||||||||||
| 4 | 2.65 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 388059 389208 396087 396121 401071 401318 401919 404584 405061 405287 417801 420050 422192 422618 423332 425523 430404 434310 434376 436942 445428 445471 445641 446373 454802 466982 468835 483978 484727 487746 488734 491392 498551 502043 508518 514070 514820 515964 517604 517654 524773 524992 525393 526052 529213 531804 533982 535460 538360 540511 541592 548556 549225 555009 558788 559577 566007 566839 574258 576623 577392 579389 591354 598552 601162 621698 622204 623330 626497 628327 630063 631163 639739 639824 641978 647948 650380 662137 663537 668549 676117 682531 699574 713564 716078 756395 ] |
||||||||||||||||||||||||||||||
| 5 | 123.60 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 388059 389208 396087 396121 401071 401318 401919 404584 405061 405287 417801 420050 422192 422618 423332 425523 430404 434310 434376 436942 445428 445471 445641 446373 454802 466982 468835 483978 484727 487746 488734 491392 498551 502043 508518 514070 514820 515964 517604 517654 524773 524992 525393 526052 529213 531804 533982 535460 538360 540511 541592 548556 549225 555009 558788 559577 566007 566839 574258 576623 577392 579389 591354 598552 601162 621698 622204 623330 626497 628327 630063 631163 639739 639824 641978 647948 650380 662137 663537 668549 676117 682531 699574 713564 716078 756395 ] |
||||||||||||||||||||||||||||||
| 6 | 1.64 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая анал черноволосая"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.28 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.