Query Metrics
7
Database Queries
7
Different statements
253.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
221.91 ms (87.64%) |
1 |
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 53396 390994 391600 395674 395727 395856 395970 396005 396035 396238 396253 396650 399824 401629 404368 405016 405093 405114 405194 406332 407662 408306 409024 410941 411078 411245 413833 414771 420999 430004 440619 441016 452095 452677 458220 459382 463783 482088 484692 490201 505040 512871 519980 523389 527234 531488 532747 536248 536665 536675 536676 536688 537184 537933 541853 542864 543858 544840 545363 545389 545409 545410 545488 559183 560197 562068 563852 564786 565256 565276 566786 574559 574776 575140 576364 576418 580669 582624 597230 597272 599835 600054 601674 604161 608431 613860 615717 623196 624247 624504 627806 627812 630537 631968 632256 632688 632701 632706 633449 634769 637026 639739 641127 641702 647898 650851 671726 675006 675009 680176 680193 692130 696997 699554 707391 728336 743325 785572 793376 811826 ] |
||||||||||||||||||||||||||||||
|
21.13 ms (8.34%) |
1 |
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 430004 53396 544840 671726 575140 463783 615717 484692 396035 406332 576364 452095 413833 565256 543858 623196 490201 420999 414771 647898 608431 597272 634769 728336 632256 562068 542864 675009 624504 537184 743325 404368 523389 527234 407662 536676 532747 405016 410941 793376 396650 396238 390994 411078 699554 395727 405093 641702 785572 545488 566786 409024 536688 537933 597230 637026 632688 696997 401629 411245 405194 405114 512871 680193 600054 613860 441016 563852 536675 391600 631968 564786 559183 519980 811826 627806 395856 650851 440619 560197 604161 632701 641127 531488 565276 639739 599835 632706 536248 536665 482088 399824 505040 408306 458220 692130 396005 395674 545409 601674 452677 707391 582624 624247 630537 633449 545363 545389 545410 627812 574559 459382 541853 675006 680176 580669 395970 396253 576418 574776 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (1.27%) |
1 |
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 53396 390994 391600 395674 395727 395856 395970 396005 396035 396238 396253 396650 399824 401629 404368 405016 405093 405114 405194 406332 407662 408306 409024 410941 411078 411245 413833 414771 420999 430004 440619 441016 452095 452677 458220 459382 463783 482088 484692 490201 505040 512871 519980 523389 527234 531488 532747 536248 536665 536675 536676 536688 537184 537933 541853 542864 543858 544840 545363 545389 545409 545410 545488 559183 560197 562068 563852 564786 565256 565276 566786 574559 574776 575140 576364 576418 580669 582624 597230 597272 599835 600054 601674 604161 608431 613860 615717 623196 624247 624504 627806 627812 630537 631968 632256 632688 632701 632706 633449 634769 637026 639739 641127 641702 647898 650851 671726 675006 675009 680176 680193 692130 696997 699554 707391 728336 743325 785572 793376 811826 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.70%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young teen глубокийминет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young teen deepthroat"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young teen глубокийминет минет оральн секс"
]
|
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.