Query Metrics
7
Database Queries
7
Different statements
146.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.32 ms (84.36%) |
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 12270 33077 39639 79826 97191 383399 384243 388583 388873 391885 394273 409077 409701 415345 424068 425385 426376 432272 434541 442164 445702 458267 460180 462260 476473 477213 480626 480927 483858 492637 493061 493921 499890 500277 501390 508760 513567 519267 522682 523174 532277 554264 556257 556522 559714 559974 562924 576197 584661 608270 609216 617029 631514 633570 638091 638524 640868 644877 650293 655800 661492 665090 666513 667461 671488 690329 690429 690494 691879 692919 693163 693176 704894 705727 709771 710293 718971 721892 722000 734210 735246 738664 741569 743439 745483 746982 747403 762031 763216 764107 766303 766383 766462 766870 768912 774028 778764 779236 779379 779493 780112 780939 781484 783399 786659 790046 791456 791459 793210 794100 798717 798777 798911 798937 799679 799930 803739 817447 817530 818735 ] |
||||||||||||||||||||||||||||||
|
13.13 ms (8.98%) |
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 425385 790046 709771 666513 409701 817447 79826 33077 556257 655800 781484 39639 388873 793210 745483 803739 798777 462260 633570 493921 690494 693163 691879 766303 798911 576197 556522 501390 391885 650293 791459 492637 532277 665090 690329 693176 638524 799679 764107 483858 735246 434541 661492 791456 762031 432272 388583 608270 722000 747403 779493 766462 783399 743439 458267 522682 704894 778764 780939 766383 794100 738664 508760 476473 442164 384243 499890 559714 559974 445702 480927 480626 562924 609216 638091 779379 779236 424068 500277 631514 394273 671488 667461 710293 690429 617029 786659 799930 798717 734210 766870 768912 12270 460180 477213 554264 640868 493061 746982 718971 415345 705727 692919 763216 741569 780112 798937 97191 426376 383399 584661 513567 818735 774028 817530 721892 409077 519267 644877 523174 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.91%) |
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 12270 33077 39639 79826 97191 383399 384243 388583 388873 391885 394273 409077 409701 415345 424068 425385 426376 432272 434541 442164 445702 458267 460180 462260 476473 477213 480626 480927 483858 492637 493061 493921 499890 500277 501390 508760 513567 519267 522682 523174 532277 554264 556257 556522 559714 559974 562924 576197 584661 608270 609216 617029 631514 633570 638091 638524 640868 644877 650293 655800 661492 665090 666513 667461 671488 690329 690429 690494 691879 692919 693163 693176 704894 705727 709771 710293 718971 721892 722000 734210 735246 738664 741569 743439 745483 746982 747403 762031 763216 764107 766303 766383 766462 766870 768912 774028 778764 779236 779379 779493 780112 780939 781484 783399 786659 790046 791456 791459 793210 794100 798717 798777 798911 798937 799679 799930 803739 817447 817530 818735 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob in car"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс вмашин"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс вмашин"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.09%) |
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.