Query Metrics
7
Database Queries
7
Different statements
239.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.53 ms (89.28%) |
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 382548 392588 397406 398106 398987 401621 411187 413335 413958 416032 418761 420178 421840 421874 421913 423929 425499 428602 429790 435376 437374 439643 440851 440932 441583 441770 441844 442057 448656 450684 455496 455882 456701 457433 457459 458385 459200 461318 461612 461619 464198 464247 466164 466236 467945 470147 471407 474582 474794 476676 477081 477135 477536 478005 478611 482947 492346 492372 493178 518763 534079 537267 563615 564549 578913 593985 604089 612977 627358 629354 681755 682348 705459 713652 720788 727460 728262 731341 731349 739985 740593 740844 740888 752121 757650 761029 761036 762272 764245 765327 765476 768394 768851 769311 769491 775764 780778 782027 783302 784209 785051 791482 791594 791800 792539 794887 795686 796153 796319 796884 799883 801214 802025 802132 807352 810318 811417 813828 827383 827526 ] |
||||||||||||||||||||||||||||||
|
15.82 ms (6.61%) |
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 731349 534079 768394 439643 466164 471407 411187 421840 420178 455496 416032 464247 413335 461318 477135 783302 757650 442057 478611 457433 769491 441770 441583 455882 761036 604089 796153 441844 458385 382548 813828 794887 796319 796884 791482 801214 448656 740844 811417 564549 791800 810318 802025 713652 563615 428602 476676 482947 769311 739985 392588 466236 418761 459200 474582 492346 827526 765476 740593 827383 791594 802132 784209 728262 762272 765327 397406 464198 493178 398106 456701 474794 478005 807352 440851 461612 425499 578913 612977 705459 470147 761029 401621 629354 780778 799883 413958 477536 727460 740888 752121 768851 450684 440932 398987 437374 792539 457459 492372 720788 682348 518763 423929 421913 785051 681755 627358 782027 461619 731341 477081 537267 467945 593985 795686 435376 775764 429790 764245 421874 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.25%) |
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 382548 392588 397406 398106 398987 401621 411187 413335 413958 416032 418761 420178 421840 421874 421913 423929 425499 428602 429790 435376 437374 439643 440851 440932 441583 441770 441844 442057 448656 450684 455496 455882 456701 457433 457459 458385 459200 461318 461612 461619 464198 464247 466164 466236 467945 470147 471407 474582 474794 476676 477081 477135 477536 478005 478611 482947 492346 492372 493178 518763 534079 537267 563615 564549 578913 593985 604089 612977 627358 629354 681755 682348 705459 713652 720788 727460 728262 731341 731349 739985 740593 740844 740888 752121 757650 761029 761036 762272 764245 765327 765476 768394 768851 769311 769491 775764 780778 782027 783302 784209 785051 791482 791594 791800 792539 794887 795686 796153 796319 796884 799883 801214 802025 802132 807352 810318 811417 813828 827383 827526 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"трахает мамку домашне…"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.66%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс мам женщин домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.60%) |
1 |
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.