Query Metrics
7
Database Queries
7
Different statements
191.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.59 ms (87.05%) |
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 387296 411737 446375 447806 452238 453113 456863 459244 460254 462712 466888 466903 466935 469317 473627 474115 476320 485392 485716 485976 486970 488902 494319 498457 515083 516077 518838 526613 527047 529353 529700 536982 538566 540560 545769 545931 546131 548052 549238 549242 549248 554352 558281 558310 560410 566814 567544 578218 583144 585132 587789 590722 592723 611795 624474 628704 629572 629834 629837 635610 649527 663375 663977 664389 664961 665278 665359 665364 665440 665476 665508 665867 666754 666786 667578 668694 668901 678766 712314 714007 725236 725244 726965 728188 728313 729286 731159 731170 736077 738296 742783 744232 744466 744990 751511 754133 755945 766660 770114 770187 774326 776133 781699 781782 782203 788481 790094 792097 794249 794647 797007 800125 800763 801029 801822 803019 807881 808000 808165 825241 ] |
||||||||||||||||||||||||||||||
|
13.99 ms (7.31%) |
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 540560 567544 546131 629572 728188 590722 578218 825241 447806 485392 460254 452238 485716 527047 558310 566814 668901 664961 665359 665364 665508 714007 665278 668694 548052 549238 592723 587789 628704 629834 629837 635610 776133 781782 792097 807881 781699 808000 744232 755945 774326 788481 790094 725244 728313 742783 744466 770114 726965 729286 731159 731170 712314 800763 516077 486970 498457 558281 538566 560410 667578 663375 663977 665440 797007 801822 801029 754133 738296 549248 456863 459244 536982 476320 545931 736077 766660 411737 529700 387296 453113 446375 462712 494319 515083 469317 549242 554352 665476 665867 666786 678766 649527 664389 666754 611795 782203 803019 794249 794647 725236 800125 808165 744990 485976 529353 473627 585132 466935 466903 466888 474115 526613 518838 488902 545769 583144 624474 751511 770187 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.59%) |
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 387296 411737 446375 447806 452238 453113 456863 459244 460254 462712 466888 466903 466935 469317 473627 474115 476320 485392 485716 485976 486970 488902 494319 498457 515083 516077 518838 526613 527047 529353 529700 536982 538566 540560 545769 545931 546131 548052 549238 549242 549248 554352 558281 558310 560410 566814 567544 578218 583144 585132 587789 590722 592723 611795 624474 628704 629572 629834 629837 635610 649527 663375 663977 664389 664961 665278 665359 665364 665440 665476 665508 665867 666754 666786 667578 668694 668901 678766 712314 714007 725236 725244 726965 728188 728313 729286 731159 731170 736077 738296 742783 744232 744466 744990 751511 754133 755945 766660 770114 770187 774326 776133 781699 781782 782203 788481 790094 792097 794249 794647 797007 800125 800763 801029 801822 803019 807881 808000 808165 825241 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits saggy granny"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сиськ saggy granny"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ saggy granny"
]
|
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.