Query Metrics
7
Database Queries
7
Different statements
180.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.41 ms (86.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 8497 109313 388783 403039 405493 406314 416242 424682 429036 429439 439622 439681 439785 439804 441234 442550 442557 444429 450028 451684 454551 458521 459689 461155 461724 462027 462034 462120 462834 466189 466708 475750 479322 481782 483663 483709 485302 486112 489487 489624 492767 493455 495482 496153 498215 504261 504543 507152 509273 514342 516042 516309 517030 519539 521643 522399 523655 525220 527336 527931 528888 531203 533418 534340 537944 537999 541540 541673 542707 549226 553931 554125 555468 557238 557749 557814 560406 560471 563140 563885 564451 565350 565468 567014 569058 569448 571834 572782 573674 574818 574910 579360 580222 583549 586057 593690 595024 597231 597272 601062 601489 604835 605372 605971 606012 606203 606223 606908 611984 620667 622821 626348 626356 627746 643364 656058 661247 675012 681301 816629 ] |
||||||||||||||||||||||||||||||
|
13.91 ms (7.70%) |
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 493455 483709 675012 109313 492767 555468 479322 604835 459689 439622 611984 534340 406314 507152 442550 523655 563885 527931 573674 489624 517030 516309 580222 537999 656058 601489 586057 626356 593690 528888 557238 606203 571834 439681 439785 441234 429439 466189 622821 462027 8497 462034 405493 516042 605971 627746 489487 569448 475750 567014 606908 533418 564451 572782 481782 450028 504543 605372 579360 522399 574910 595024 439804 527336 519539 597272 541673 514342 643364 461155 416242 661247 681301 583549 569058 486112 565468 542707 549226 537944 525220 560471 504261 606012 424682 403039 461724 560406 574818 565350 454551 521643 483663 495482 541540 620667 597231 816629 458521 563140 557749 557814 601062 606223 626348 496153 531203 388783 553931 451684 498215 466708 485302 554125 429036 462120 509273 442557 462834 444429 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (1.76%) |
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 8497 109313 388783 403039 405493 406314 416242 424682 429036 429439 439622 439681 439785 439804 441234 442550 442557 444429 450028 451684 454551 458521 459689 461155 461724 462027 462034 462120 462834 466189 466708 475750 479322 481782 483663 483709 485302 486112 489487 489624 492767 493455 495482 496153 498215 504261 504543 507152 509273 514342 516042 516309 517030 519539 521643 522399 523655 525220 527336 527931 528888 531203 533418 534340 537944 537999 541540 541673 542707 549226 553931 554125 555468 557238 557749 557814 560406 560471 563140 563885 564451 565350 565468 567014 569058 569448 571834 572782 573674 574818 574910 579360 580222 583549 586057 593690 595024 597231 597272 601062 601489 604835 605372 605971 606012 606203 606223 606908 611984 620667 622821 626348 626356 627746 643364 656058 661247 675012 681301 816629 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"thong blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"стринг нижн бел минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.