Query Metrics
7
Database Queries
7
Different statements
163.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.56 ms (83.53%) |
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 382276 397555 398431 399475 405742 424056 443248 446815 457774 460474 462584 466016 466645 476769 477908 488733 491809 492805 494318 496041 496800 500878 503706 505333 516348 516647 519994 521902 522246 532006 536331 538201 538217 540139 541865 545539 546745 549364 549384 551999 552602 552604 554893 556051 556352 563206 563772 565359 565371 565499 565565 566031 568503 569422 570869 574908 579520 580335 580971 583469 585136 585397 585680 590813 592417 599130 601438 603082 603095 604915 605581 614662 618725 624023 626907 629604 635234 650919 653328 656107 665182 665490 670265 672388 680137 681457 688997 689490 689565 690658 701917 718581 718665 721280 721839 727759 729552 741647 744612 747442 747944 754480 774468 777619 778975 778980 782123 783267 783939 789212 789888 792388 801227 802827 802832 805212 807067 808523 810863 821120 ] |
||||||||||||||||||||||||||||||
|
17.51 ms (10.71%) |
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 552602 585680 604915 624023 802832 466645 538217 538201 551999 603082 398431 774468 821120 476769 446815 460474 462584 532006 540139 505333 516647 519994 516348 522246 536331 546745 549384 554893 556352 563206 563772 570869 541865 569422 583469 549364 680137 681457 688997 690658 701917 650919 656107 672388 689490 670265 689565 718665 552604 601438 614662 629604 618725 585397 599130 605581 626907 783267 789888 792388 807067 777619 778980 801227 810863 782123 783939 789212 808523 747442 741647 729552 727759 744612 747944 754480 718581 721280 721839 778975 802827 805212 405742 443248 466016 397555 399475 477908 382276 494318 496041 503706 491809 496800 521902 488733 585136 545539 568503 565371 566031 556051 565499 574908 579520 665490 565359 565565 592417 603095 590813 635234 424056 457774 580335 500878 492805 580971 665182 653328 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.46%) |
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 382276 397555 398431 399475 405742 424056 443248 446815 457774 460474 462584 466016 466645 476769 477908 488733 491809 492805 494318 496041 496800 500878 503706 505333 516348 516647 519994 521902 522246 532006 536331 538201 538217 540139 541865 545539 546745 549364 549384 551999 552602 552604 554893 556051 556352 563206 563772 565359 565371 565499 565565 566031 568503 569422 570869 574908 579520 580335 580971 583469 585136 585397 585680 590813 592417 599130 601438 603082 603095 604915 605581 614662 618725 624023 626907 629604 635234 650919 653328 656107 665182 665490 670265 672388 680137 681457 688997 689490 689565 690658 701917 718581 718665 721280 721839 727759 729552 741647 744612 747442 747944 754480 774468 777619 778975 778980 782123 783267 783939 789212 789888 792388 801227 802827 802832 805212 807067 808523 810863 821120 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small tits shower"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая сиськ shower"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая сиськ shower"
]
|
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.