Query Metrics
7
Database Queries
7
Different statements
250.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
221.34 ms (88.47%) |
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 389364 392418 398877 401202 401921 408832 412367 414516 416970 419218 420060 422288 425960 427553 428961 442943 446560 447865 449363 452286 452554 452593 455912 455933 456040 456837 462095 463077 464366 464621 465745 466410 470779 470856 471690 471818 474383 474813 475805 478208 479148 480197 484084 486277 487588 488888 490063 498014 498816 499147 500566 500980 505318 505523 514999 515749 518118 519904 519908 521525 523236 525439 527602 530762 533576 537208 544576 544753 547919 548849 551212 556415 557260 557526 559373 559564 559837 560202 562049 562853 562892 564417 564814 566247 569830 571832 576384 581662 584827 586910 591647 593009 593050 599144 599317 602000 602019 604051 618476 620801 621396 623805 623818 624909 629045 633114 650218 652572 653545 654314 659409 674081 676463 720871 748741 771517 780419 792612 815714 821370 ] |
||||||||||||||||||||||||||||||
|
18.91 ms (7.56%) |
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 478208 488888 471690 518118 624909 792612 425960 821370 498816 548849 650218 748741 408832 815714 463077 464621 475805 557260 566247 559373 653545 674081 551212 562049 584827 593050 392418 452554 462095 401921 428961 479148 466410 474813 442943 455933 523236 659409 389364 427553 416970 420060 419218 456837 486277 525439 533576 505523 544576 544753 559564 720871 564417 593009 623805 780419 771517 474383 401202 414516 446560 470856 422288 499147 464366 490063 484084 456040 447865 487588 521525 505318 562853 576384 581662 562892 676463 620801 602000 602019 449363 452593 470779 514999 500566 530762 599144 527602 471818 519904 571832 556415 559837 621396 465745 412367 537208 519908 569830 560202 654314 547919 557526 564814 586910 633114 452286 480197 515749 500980 498014 629045 398877 604051 618476 623818 455912 591647 652572 599317 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.07%) |
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 389364 392418 398877 401202 401921 408832 412367 414516 416970 419218 420060 422288 425960 427553 428961 442943 446560 447865 449363 452286 452554 452593 455912 455933 456040 456837 462095 463077 464366 464621 465745 466410 470779 470856 471690 471818 474383 474813 475805 478208 479148 480197 484084 486277 487588 488888 490063 498014 498816 499147 500566 500980 505318 505523 514999 515749 518118 519904 519908 521525 523236 525439 527602 530762 533576 537208 544576 544753 547919 548849 551212 556415 557260 557526 559373 559564 559837 560202 562049 562853 562892 564417 564814 566247 569830 571832 576384 581662 584827 586910 591647 593009 593050 599144 599317 602000 602019 604051 618476 620801 621396 623805 623818 624909 629045 633114 650218 652572 653545 654314 659409 674081 676463 720871 748741 771517 780419 792612 815714 821370 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза body"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.69%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лиза body"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"licking body"
]
|
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.