Query Metrics
7
Database Queries
7
Different statements
175.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.43 ms (82.67%) |
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 412367 418607 426399 427553 438374 448260 452286 452317 452456 454165 454188 456040 460479 462096 465745 467733 470779 471818 475078 477339 480197 484418 486941 487588 490063 490738 498014 498402 498417 500980 501461 502453 507916 509691 510321 510769 511518 514999 515433 515542 515749 517710 518118 518768 519904 519908 519911 519914 521021 522998 523035 524084 524297 526241 527602 529306 529846 530756 530759 533455 537208 537487 538161 539192 540026 547919 548849 552286 553920 556415 557526 559837 560097 560202 560837 562373 564417 564814 565978 569830 571832 576384 577391 581662 583021 583894 583966 586600 586910 587751 587946 589105 593129 594422 602019 605418 605735 606508 614036 621396 622391 622392 622394 622397 624390 624909 625164 629045 633114 638540 647850 650218 655582 659409 676463 691335 748741 792612 813073 821370 ] |
||||||||||||||||||||||||||||||
|
20.83 ms (11.84%) |
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 602019 524084 813073 470779 553920 691335 586600 605735 515542 475078 529306 487588 538161 418607 624909 577391 655582 622394 622392 524297 427553 540026 552286 564417 412367 452456 518118 522998 583966 467733 548849 821370 587751 514999 511518 650218 484418 490738 438374 621396 530756 533455 792612 527602 462096 498417 498402 589105 515433 583894 502453 454165 576384 509691 587946 456040 510769 565978 581662 571832 593129 510321 676463 559837 638540 452317 519904 448260 560097 569830 517710 560837 594422 622391 622397 521021 530759 526241 452286 454188 519908 480197 460479 501461 523035 614036 586910 518768 426399 465745 748741 625164 486941 515749 471818 500980 564814 647850 557526 519914 539192 477339 560202 507916 498014 537208 624390 556415 529846 547919 490063 537487 583021 659409 606508 605418 633114 519911 629045 562373 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.54%) |
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 412367 418607 426399 427553 438374 448260 452286 452317 452456 454165 454188 456040 460479 462096 465745 467733 470779 471818 475078 477339 480197 484418 486941 487588 490063 490738 498014 498402 498417 500980 501461 502453 507916 509691 510321 510769 511518 514999 515433 515542 515749 517710 518118 518768 519904 519908 519911 519914 521021 522998 523035 524084 524297 526241 527602 529306 529846 530756 530759 533455 537208 537487 538161 539192 540026 547919 548849 552286 553920 556415 557526 559837 560097 560202 560837 562373 564417 564814 565978 569830 571832 576384 577391 581662 583021 583894 583966 586600 586910 587751 587946 589105 593129 594422 602019 605418 605735 606508 614036 621396 622391 622392 622394 622397 624390 624909 625164 629045 633114 638540 647850 650218 655582 659409 676463 691335 748741 792612 813073 821370 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big body sex"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие body секс"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие body секс"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.75%) |
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.