Query Metrics
7
Database Queries
7
Different statements
172.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.81 ms (85.30%) |
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 68869 91532 384963 399858 405716 408502 409184 409310 417935 426722 437291 444198 445699 446139 449053 454405 455764 460954 462548 465473 471768 473710 478905 479511 479700 482602 483327 484431 489943 490164 491322 491801 494178 496228 497546 499427 499526 502464 503535 509393 510625 510988 511594 511598 511825 511852 518628 520340 522053 522521 527057 531702 538407 544927 546359 554514 555058 556753 559051 560018 560505 562029 562141 562772 566041 566689 567493 568718 570238 570674 571104 573070 576038 577927 578584 581217 581988 585518 588323 588359 589416 591189 593161 593691 600724 602480 615658 619092 619372 622796 624320 624601 627171 651765 653073 666509 667919 673217 690693 691758 698228 712553 718864 739905 742758 742782 743120 743813 747776 748662 758385 758417 763624 766143 770615 797352 803846 804191 807786 813387 ] |
||||||||||||||||||||||||||||||
|
15.01 ms (8.72%) |
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 622796 804191 544927 742758 494178 624601 91532 577927 384963 766143 560018 554514 510625 807786 758417 581988 499427 568718 593691 758385 503535 743813 712553 538407 698228 484431 666509 797352 813387 742782 444198 68869 691758 566689 471768 405716 449053 490164 581217 739905 445699 570238 571104 718864 497546 454405 690693 562141 562772 570674 651765 627171 653073 673217 546359 555058 588323 556753 747776 522521 573070 770615 560505 593161 465473 803846 624320 509393 602480 522053 408502 460954 473710 491801 446139 511594 531702 743120 417935 578584 588359 455764 511598 600724 591189 667919 763624 589416 566041 399858 409310 510988 585518 619092 748662 619372 576038 426722 437291 562029 496228 479511 409184 511852 615658 489943 527057 499526 483327 478905 520340 491322 479700 502464 462548 482602 518628 559051 567493 511825 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.62%) |
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 68869 91532 384963 399858 405716 408502 409184 409310 417935 426722 437291 444198 445699 446139 449053 454405 455764 460954 462548 465473 471768 473710 478905 479511 479700 482602 483327 484431 489943 490164 491322 491801 494178 496228 497546 499427 499526 502464 503535 509393 510625 510988 511594 511598 511825 511852 518628 520340 522053 522521 527057 531702 538407 544927 546359 554514 555058 556753 559051 560018 560505 562029 562141 562772 566041 566689 567493 568718 570238 570674 571104 573070 576038 577927 578584 581217 581988 585518 588323 588359 589416 591189 593161 593691 600724 602480 615658 619092 619372 622796 624320 624601 627171 651765 653073 666509 667919 673217 690693 691758 698228 712553 718864 739905 742758 742782 743120 743813 747776 748662 758385 758417 763624 766143 770615 797352 803846 804191 807786 813387 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ебл в рот"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс в рот"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс в рот"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.