Query Metrics
7
Database Queries
7
Different statements
200.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.01 ms (87.20%) |
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 12775 202134 325910 388856 393472 404804 417823 418530 419131 421579 423482 424384 427138 428034 430807 437558 437947 438013 439027 441160 446645 447566 450599 451100 452300 453332 453346 457696 460226 462849 463915 464696 468145 472706 473992 475144 475769 477691 478036 478038 480383 480395 480397 480402 480406 480413 484552 492732 497417 498468 498582 499844 508380 510170 514768 514845 516568 518446 519562 520789 521794 523274 523393 527882 530728 532727 532939 548157 548167 548966 550124 559737 561946 565263 574387 584351 588231 588818 595441 600200 622233 624281 631173 632562 633607 634139 634533 637043 641681 645248 666877 671675 675858 680460 710161 714612 716522 719781 720459 736943 738625 743345 744061 758190 758554 773856 787438 790330 791095 796881 800876 815298 815619 815624 815921 816067 816363 816388 816441 816968 ] |
||||||||||||||||||||||||||||||
|
16.95 ms (8.44%) |
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 634533 12775 815298 815619 815921 816388 816441 816363 527882 530728 559737 716522 719781 720459 791095 787438 743345 758554 758190 744061 441160 473992 514845 523393 437558 446645 464696 453332 520789 388856 460226 202134 423482 439027 424384 480383 510170 516568 519562 548157 574387 548966 565263 714612 680460 588231 633607 480395 427138 498582 484552 497417 736943 451100 457696 584351 421579 430807 468145 480397 450599 498468 518446 588818 634139 816067 816968 815624 521794 508380 671675 675858 548167 632562 773856 738625 631173 800876 404804 475769 523274 325910 393472 417823 478038 532727 532939 624281 463915 472706 499844 478036 480402 561946 595441 796881 447566 477691 428034 418530 419131 462849 492732 790330 437947 453346 475144 480413 666877 710161 645248 622233 641681 452300 438013 480406 550124 637043 514768 600200 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.23%) |
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 12775 202134 325910 388856 393472 404804 417823 418530 419131 421579 423482 424384 427138 428034 430807 437558 437947 438013 439027 441160 446645 447566 450599 451100 452300 453332 453346 457696 460226 462849 463915 464696 468145 472706 473992 475144 475769 477691 478036 478038 480383 480395 480397 480402 480406 480413 484552 492732 497417 498468 498582 499844 508380 510170 514768 514845 516568 518446 519562 520789 521794 523274 523393 527882 530728 532727 532939 548157 548167 548966 550124 559737 561946 565263 574387 584351 588231 588818 595441 600200 622233 624281 631173 632562 633607 634139 634533 637043 641681 645248 666877 671675 675858 680460 710161 714612 716522 719781 720459 736943 738625 743345 744061 758190 758554 773856 787438 790330 791095 796881 800876 815298 815619 815624 815921 816067 816363 816388 816441 816968 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal wet"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал мокрые"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.68%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.