Query Metrics
7
Database Queries
7
Different statements
179.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.96 ms (81.21%) |
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 6739 6768 13250 39054 75979 83894 319863 366284 381822 385731 391037 396127 401692 402261 402381 425903 429409 437325 440762 445843 457388 457685 460444 461368 463111 463631 468189 473574 476453 483280 487074 487643 491356 492238 494290 498225 500392 502464 502614 506241 512427 519735 522401 527696 532058 535933 537288 538793 540934 542299 544862 544969 547117 549386 549738 552770 557744 560879 562208 566605 567471 567910 572876 574417 577552 579752 586556 590855 595502 597852 608560 608878 608926 610616 622894 625753 626627 646154 650691 660250 660352 665268 665428 670280 707346 711826 716491 717919 718616 727964 730763 732491 735186 736547 738734 755482 758911 759021 760208 764095 764388 774084 782175 783724 794181 794379 796546 796620 798710 800688 801219 802721 803876 804119 805609 810139 811356 813278 813475 814310 ] |
||||||||||||||||||||||||||||||
|
20.88 ms (11.62%) |
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 487643 463111 535933 445843 527696 549738 625753 437325 487074 494290 461368 716491 759021 758911 711826 502614 586556 498225 512427 6768 646154 805609 798710 366284 396127 542299 650691 802721 506241 6739 402381 567910 460444 608560 13250 401692 660352 796546 730763 800688 811356 574417 577552 440762 665428 597852 457388 610616 457685 560879 502464 590855 810139 468189 500392 562208 814310 544969 783724 319863 473574 557744 608878 813278 463631 483280 402261 39054 665268 804119 813475 381822 566605 83894 75979 537288 540934 572876 567471 660250 718616 717919 626627 622894 794379 764388 774084 794181 736547 732491 735186 782175 796620 522401 707346 670280 579752 595502 755482 801219 764095 738734 760208 727964 803876 608926 425903 491356 538793 476453 519735 492238 385731 532058 547117 549386 544862 552770 429409 391037 ] |
||||||||||||||||||||||||||||||
|
5.46 ms (3.04%) |
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 6739 6768 13250 39054 75979 83894 319863 366284 381822 385731 391037 396127 401692 402261 402381 425903 429409 437325 440762 445843 457388 457685 460444 461368 463111 463631 468189 473574 476453 483280 487074 487643 491356 492238 494290 498225 500392 502464 502614 506241 512427 519735 522401 527696 532058 535933 537288 538793 540934 542299 544862 544969 547117 549386 549738 552770 557744 560879 562208 566605 567471 567910 572876 574417 577552 579752 586556 590855 595502 597852 608560 608878 608926 610616 622894 625753 626627 646154 650691 660250 660352 665268 665428 670280 707346 711826 716491 717919 718616 727964 730763 732491 735186 736547 738734 755482 758911 759021 760208 764095 764388 774084 782175 783724 794181 794379 796546 796620 798710 800688 801219 802721 803876 804119 805609 810139 811356 813278 813475 814310 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс в жизнь"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс в"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.89%) |
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.