Query Metrics
7
Database Queries
7
Different statements
200.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.62 ms (85.51%) |
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 108208 331119 338587 387682 390569 401738 402105 406954 408601 418009 418706 420202 422595 422712 422871 423132 423396 435066 435449 443215 443600 446870 451259 452513 453016 456730 464893 465234 471822 473771 476154 480775 485576 490956 491456 495121 499037 508485 508487 510266 510582 511489 512680 513798 517862 518949 519769 520640 521249 525178 525208 528777 529849 529854 530663 531083 532249 532345 535259 539938 540608 543874 545602 550985 554418 556030 557265 558410 559093 560216 561882 562872 565215 565481 565943 571824 572048 575505 575831 578437 579389 580197 580272 581972 583254 595945 595952 598247 598252 600460 600522 600613 601200 603102 604429 605430 607705 614730 616536 623446 623950 623969 634422 636288 646004 651620 673099 674641 678159 681377 683608 709919 711668 732014 737326 749478 760206 818390 820780 827983 ] |
||||||||||||||||||||||||||||||
|
18.38 ms (9.16%) |
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 636288 108208 674641 749478 331119 453016 528777 560216 571824 651620 580272 600460 595952 595945 601200 451259 583254 387682 711668 737326 543874 603102 435449 510266 535259 545602 408601 422595 422712 529854 530663 512680 539938 540608 511489 646004 565481 456730 443600 519769 485576 508485 554418 550985 580197 614730 518949 390569 473771 491456 521249 480775 422871 532249 401738 818390 827983 557265 565215 565943 578437 683608 681377 600613 623950 600522 623969 581972 423132 529849 532345 673099 634422 418706 575831 561882 558410 572048 709919 446870 556030 579389 531083 465234 510582 435066 420202 820780 464893 525178 499037 476154 471822 517862 513798 525208 520640 616536 338587 605430 598247 508487 678159 452513 406954 490956 604429 760206 732014 402105 443215 495121 423396 418009 575505 559093 562872 598252 607705 623446 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.55%) |
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 108208 331119 338587 387682 390569 401738 402105 406954 408601 418009 418706 420202 422595 422712 422871 423132 423396 435066 435449 443215 443600 446870 451259 452513 453016 456730 464893 465234 471822 473771 476154 480775 485576 490956 491456 495121 499037 508485 508487 510266 510582 511489 512680 513798 517862 518949 519769 520640 521249 525178 525208 528777 529849 529854 530663 531083 532249 532345 535259 539938 540608 543874 545602 550985 554418 556030 557265 558410 559093 560216 561882 562872 565215 565481 565943 571824 572048 575505 575831 578437 579389 580197 580272 581972 583254 595945 595952 598247 598252 600460 600522 600613 601200 603102 604429 605430 607705 614730 616536 623446 623950 623969 634422 636288 646004 651620 673099 674641 678159 681377 683608 709919 711668 732014 737326 749478 760206 818390 820780 827983 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большой большие член азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big dick asian"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большой большие член азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.87%) |
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.