Query Metrics
7
Database Queries
7
Different statements
419.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
397.71 ms (94.85%) |
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 191474 394874 403577 404311 407681 409180 415580 448949 449099 450241 452307 453259 453262 453263 474817 481943 482186 489921 493160 506713 534572 536348 554978 563731 569182 579998 583154 588942 590261 591111 591112 591121 595469 604928 605362 606640 607450 608430 608432 612199 616505 624374 627277 628994 629852 639631 648189 649634 669220 677557 684106 688016 688668 693683 698916 705256 705385 708125 710249 710339 712333 713612 714873 716818 717355 717611 717741 718329 721141 723981 725464 726649 728877 733032 735532 736015 736262 736752 738276 739200 740136 742612 743780 744479 745200 745410 747041 751721 756402 758765 759751 761252 768881 769432 770570 771358 773472 780559 781911 790821 796541 797016 805894 808021 810982 813770 814538 815411 815497 816302 816394 816525 817851 818161 818252 819583 823957 824560 824802 825924 ] |
||||||||||||||||||||||||||||||
|
13.04 ms (3.11%) |
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 736262 743780 506713 698916 595469 761252 639631 705385 415580 450241 474817 449099 482186 583154 810982 404311 403577 493160 191474 813770 817851 825924 814538 818161 819583 815497 816394 816302 823957 563731 669220 677557 713612 717355 684106 718329 649634 688016 693683 705256 708125 712333 569182 579998 590261 588942 591111 591121 608432 629852 591112 605362 780559 723981 736015 739200 769432 797016 735532 745200 771358 738276 725464 770570 710339 721141 790821 796541 808021 489921 648189 768881 716818 616505 606640 758765 452307 481943 394874 409180 815411 824802 448949 453259 453262 453263 534572 536348 554978 717611 688668 710249 717741 604928 607450 612199 624374 608430 627277 781911 805894 740136 759751 726649 733032 728877 745410 751721 773472 742612 756402 407681 816525 628994 818252 824560 714873 736752 744479 747041 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (0.58%) |
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 191474 394874 403577 404311 407681 409180 415580 448949 449099 450241 452307 453259 453262 453263 474817 481943 482186 489921 493160 506713 534572 536348 554978 563731 569182 579998 583154 588942 590261 591111 591112 591121 595469 604928 605362 606640 607450 608430 608432 612199 616505 624374 627277 628994 629852 639631 648189 649634 669220 677557 684106 688016 688668 693683 698916 705256 705385 708125 710249 710339 712333 713612 714873 716818 717355 717611 717741 718329 721141 723981 725464 726649 728877 733032 735532 736015 736262 736752 738276 739200 740136 742612 743780 744479 745200 745410 747041 751721 756402 758765 759751 761252 768881 769432 770570 771358 773472 780559 781911 790821 796541 797016 805894 808021 810982 813770 814538 815411 815497 816302 816394 816525 817851 818161 818252 819583 823957 824560 824802 825924 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие cock milf"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big cock milf"
]
|
||||||||||||||||||||||||||||||
|
1.29 ms (0.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие cock milf"
]
|
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.