Query Metrics
7
Database Queries
7
Different statements
181.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.64 ms (84.45%) |
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 34462 154535 154707 197398 391954 401035 401816 402631 411885 419640 421303 426167 427942 443422 444235 445098 445365 454909 462605 463855 465205 468123 468766 469350 471185 494540 498525 501702 505343 506260 515418 517873 517879 523759 524795 524803 528929 530791 536503 536557 536582 539599 547631 548264 550324 552089 556789 559305 562004 562012 562019 562797 563927 565031 571826 580850 582794 586572 587559 591344 594821 595189 602821 607599 607638 609696 610626 617009 619644 622411 624405 626866 628633 634849 636478 649644 656672 663263 664798 665210 665292 667498 668701 668834 669346 671356 689660 701875 707356 715460 715462 716246 716797 717607 719203 720235 722541 727256 732161 732428 738475 752094 755424 758322 764321 770949 773681 774699 778384 781826 784681 785387 787130 787792 788154 788858 790768 804234 807894 826278 ] |
||||||||||||||||||||||||||||||
|
17.28 ms (9.50%) |
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 617009 419640 515418 701875 719203 663263 607638 787130 788858 787792 738475 773681 536557 471185 550324 469350 609696 445365 539599 580850 582794 610626 391954 462605 505343 563927 732161 778384 402631 411885 707356 34462 717607 758322 154535 716246 665210 667498 664798 547631 626866 524795 444235 421303 445098 501702 715462 668701 804234 774699 781826 784681 607599 401035 443422 523759 536582 565031 720235 649644 595189 807894 752094 524803 562004 562797 788154 602821 656672 154707 494540 689660 634849 785387 732428 401816 559305 669346 587559 530791 536503 426167 591344 586572 463855 826278 556789 624405 197398 506260 636478 755424 465205 622411 790768 770949 498525 571826 715460 722541 468123 517879 562019 562012 671356 619644 628633 454909 517873 468766 552089 548264 665292 764321 427942 594821 727256 716797 668834 528929 ] |
||||||||||||||||||||||||||||||
|
3.66 ms (2.01%) |
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 34462 154535 154707 197398 391954 401035 401816 402631 411885 419640 421303 426167 427942 443422 444235 445098 445365 454909 462605 463855 465205 468123 468766 469350 471185 494540 498525 501702 505343 506260 515418 517873 517879 523759 524795 524803 528929 530791 536503 536557 536582 539599 547631 548264 550324 552089 556789 559305 562004 562012 562019 562797 563927 565031 571826 580850 582794 586572 587559 591344 594821 595189 602821 607599 607638 609696 610626 617009 619644 622411 624405 626866 628633 634849 636478 649644 656672 663263 664798 665210 665292 667498 668701 668834 669346 671356 689660 701875 707356 715460 715462 716246 716797 717607 719203 720235 722541 727256 732161 732428 738475 752094 755424 758322 764321 770949 773681 774699 778384 781826 784681 785387 787130 787792 788154 788858 790768 804234 807894 826278 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big huge tits"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие огромные сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие огромные сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.92%) |
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.