Query Metrics
7
Database Queries
7
Different statements
165.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.76 ms (85.09%) |
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 15190 39843 95988 97823 105224 110738 185013 230974 310742 358879 359723 382441 382771 383778 385189 385264 385953 387279 391490 393049 393243 396159 396685 396866 398269 398632 398783 398981 400125 400685 400746 400815 402870 408607 411307 415191 416821 419063 424831 443420 444666 447252 448724 448990 452928 453834 456589 461414 463948 466294 475611 482185 482882 506110 512173 524700 526658 526696 551204 551979 555052 557430 560149 562315 567383 567388 590970 591715 598611 601271 606532 610084 649832 657077 670003 671305 672388 676498 677048 681012 681118 684251 687241 689591 695847 696722 706348 715891 721137 721412 722206 725310 727614 730769 731428 736879 747324 754654 756281 763072 763460 766420 766615 770394 770433 772583 774091 777169 777566 785490 786044 791034 795170 804052 810414 810578 812511 818177 820784 ] |
||||||||||||||||||||||||||||||
|
14.37 ms (8.69%) |
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 453834 382441 684251 567383 526696 671305 590970 598611 736879 756281 696722 812511 791034 419063 452928 722206 606532 727614 398269 567388 383778 804052 387279 110738 385953 400685 770394 649832 681012 786044 416821 591715 824705 39843 358879 672388 105224 512173 557430 747324 400815 385264 398981 398632 396685 185013 676498 391490 506110 610084 424831 402870 448990 754654 443420 562315 230974 393243 482185 393049 763072 526658 818177 447252 456589 444666 461414 408607 482882 463948 560149 448724 411307 396866 400125 310742 820784 555052 657077 601271 777169 810578 725310 730769 810414 731428 763460 772583 15190 398783 524700 382771 385189 670003 359723 551204 551979 677048 689591 770433 715891 706348 795170 774091 396159 95988 721412 466294 687241 475611 681118 695847 777566 766420 766615 721137 785490 97823 400746 415191 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.82%) |
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 15190 39843 95988 97823 105224 110738 185013 230974 310742 358879 359723 382441 382771 383778 385189 385264 385953 387279 391490 393049 393243 396159 396685 396866 398269 398632 398783 398981 400125 400685 400746 400815 402870 408607 411307 415191 416821 419063 424831 443420 444666 447252 448724 448990 452928 453834 456589 461414 463948 466294 475611 482185 482882 506110 512173 524700 526658 526696 551204 551979 555052 557430 560149 562315 567383 567388 590970 591715 598611 601271 606532 610084 649832 657077 670003 671305 672388 676498 677048 681012 681118 684251 687241 689591 695847 696722 706348 715891 721137 721412 722206 725310 727614 730769 731428 736879 747324 754654 756281 763072 763460 766420 766615 770394 770433 772583 774091 777169 777566 785490 786044 791034 795170 804052 810414 810578 812511 818177 820784 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brunette blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"черноволосая минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.