Query Metrics
7
Database Queries
7
Different statements
157.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.30 ms (81.55%) |
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 6666 69611 391690 393660 396568 399266 399379 401031 401734 406064 415155 417827 418038 424901 427176 428385 429037 429286 429301 430285 430379 430429 443116 443457 446335 448041 450256 451571 451830 452269 461538 462045 468557 472429 473225 473920 475725 475778 477482 478491 478569 478773 480429 481806 482961 484841 485467 486161 486169 486766 487114 488721 491381 497568 497684 508193 508850 511713 514618 515236 517869 517937 518015 520157 521897 521943 522809 523293 531657 533384 534590 539155 543260 544393 545675 548588 551260 551416 556327 556961 557933 558652 560599 565416 567014 568001 571627 571672 571865 573081 573543 573568 575524 578434 580614 580757 582134 582346 592385 594280 601536 604128 604490 604567 606694 607091 607101 613452 614110 617618 646846 657398 661283 712021 720295 722529 738855 744647 749541 789013 ] |
||||||||||||||||||||||||||||||
|
17.91 ms (11.38%) |
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 522809 508850 488721 556327 6666 446335 533384 508193 497684 571627 548588 551260 551416 573568 657398 722529 557933 571672 580757 614110 749541 401734 418038 430285 475778 429037 450256 461538 415155 462045 430379 511713 514618 521897 427176 478569 539155 573543 558652 661283 424901 429286 443116 475725 486169 486766 468557 477482 481806 517937 534590 712021 606694 607101 617618 789013 738855 473225 478773 391690 429301 448041 451571 517869 473920 480429 472429 497568 515236 543260 720295 604567 607091 601536 417827 69611 393660 485467 582346 571865 580614 594280 604128 484841 487114 443457 486161 482961 646846 582134 604490 592385 744647 613452 428385 399379 491381 406064 430429 531657 578434 478491 521943 523293 518015 396568 399266 401031 452269 451830 520157 545675 567014 568001 560599 573081 544393 565416 556961 575524 ] |
||||||||||||||||||||||||||||||
|
3.49 ms (2.22%) |
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 6666 69611 391690 393660 396568 399266 399379 401031 401734 406064 415155 417827 418038 424901 427176 428385 429037 429286 429301 430285 430379 430429 443116 443457 446335 448041 450256 451571 451830 452269 461538 462045 468557 472429 473225 473920 475725 475778 477482 478491 478569 478773 480429 481806 482961 484841 485467 486161 486169 486766 487114 488721 491381 497568 497684 508193 508850 511713 514618 515236 517869 517937 518015 520157 521897 521943 522809 523293 531657 533384 534590 539155 543260 544393 545675 548588 551260 551416 556327 556961 557933 558652 560599 565416 567014 568001 571627 571672 571865 573081 573543 573568 575524 578434 580614 580757 582134 582346 592385 594280 601536 604128 604490 604567 606694 607091 607101 613452 614110 617618 646846 657398 661283 712021 720295 722529 738855 744647 749541 789013 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc skinny fuck"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc худые секс"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc худые секс"
]
|
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.