Query Metrics
7
Database Queries
7
Different statements
274.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
247.88 ms (90.25%) |
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 82252 385137 404354 411845 411846 428977 435665 436304 445057 448623 459801 465477 470118 475873 478098 486304 486883 489272 489288 491587 491670 492681 495725 512902 513125 513909 516745 517814 518238 523042 527529 527568 529025 529048 529074 529075 529188 529190 532753 535026 535038 535057 536766 540286 540483 552952 556521 557745 562513 563259 564633 566020 566030 566033 566034 566041 566318 570728 574808 575094 575210 575514 575734 578088 579807 581928 586650 587202 591658 594942 596226 598985 600387 601472 605302 605345 605950 613356 623165 630528 630544 633732 634546 636813 637063 637662 640731 640737 645905 646200 649857 667791 669192 671407 671760 679798 689139 714117 716812 717410 718784 722199 722258 722594 725149 727698 730724 732413 732423 732425 743117 756523 773683 780868 789845 801232 802953 807967 809121 810744 ] |
||||||||||||||||||||||||||||||
|
16.56 ms (6.03%) |
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 492681 535057 513909 563259 613356 634546 527568 404354 448623 552952 556521 566030 671407 716812 645905 646200 671760 689139 605950 637662 594942 591658 807967 801232 802953 809121 640731 640737 529025 535026 535038 596226 637063 605345 436304 486883 566033 575210 411846 489272 529075 518238 82252 529190 564633 566318 722594 598985 789845 810744 727698 732413 732425 756523 773683 385137 428977 445057 489288 529048 517814 527529 566034 578088 581928 649857 669192 718784 667791 714117 722199 587202 623165 636813 605302 630528 780868 730724 743117 732423 725149 459801 491587 532753 536766 529074 411845 575094 575514 575734 491670 486304 540483 633732 435665 465477 470118 475873 478098 495725 512902 523042 529188 513125 540286 516745 562513 570728 574808 579807 566020 679798 717410 722258 557745 566041 601472 600387 586650 630544 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.08%) |
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 82252 385137 404354 411845 411846 428977 435665 436304 445057 448623 459801 465477 470118 475873 478098 486304 486883 489272 489288 491587 491670 492681 495725 512902 513125 513909 516745 517814 518238 523042 527529 527568 529025 529048 529074 529075 529188 529190 532753 535026 535038 535057 536766 540286 540483 552952 556521 557745 562513 563259 564633 566020 566030 566033 566034 566041 566318 570728 574808 575094 575210 575514 575734 578088 579807 581928 586650 587202 591658 594942 596226 598985 600387 601472 605302 605345 605950 613356 623165 630528 630544 633732 634546 636813 637063 637662 640731 640737 645905 646200 649857 667791 669192 671407 671760 679798 689139 714117 716812 717410 718784 722199 722258 722594 725149 727698 730724 732413 732423 732425 743117 756523 773683 780868 789845 801232 802953 807967 809121 810744 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"casting porn"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.70%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кастинг porn"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"кастинг porn"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.60%) |
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.