Query Metrics
7
Database Queries
7
Different statements
150.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.92 ms (82.34%) |
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 152973 172220 381890 391045 391822 397695 398579 400495 419344 421590 433758 437959 438032 438049 439476 449517 453078 454472 456416 457321 459289 462649 466758 472065 475305 484246 484281 486318 487823 488851 489778 489779 494658 495898 496115 496591 498171 500597 501977 504365 505949 507172 509631 514953 518410 518643 526122 527293 527352 531326 531897 535058 544517 545632 549175 550427 551570 552714 556093 556158 558100 562953 564670 566455 566920 567522 570878 571744 572286 574967 581938 583100 586188 586228 586997 589833 598420 606363 606792 619920 624015 624600 626145 628014 628730 631284 631571 636139 639157 670211 670251 680395 710509 718703 723144 724103 724790 725501 726067 728872 731167 736483 745980 746159 746331 746594 757245 761150 761216 764958 765934 768289 768456 769245 769543 777536 778989 786403 791101 813298 ] |
||||||||||||||||||||||||||||||
|
16.03 ms (10.65%) |
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 571744 526122 531326 564670 745980 500597 619920 398579 449517 454472 484281 527352 670251 606363 724103 172220 391045 419344 489778 489779 495898 514953 551570 550427 574967 670211 545632 589833 628014 624015 778989 777536 731167 746159 746594 791101 765934 724790 761216 725501 736483 768289 728872 397695 456416 400495 438032 498171 505949 496591 507172 504365 598420 586228 466758 152973 566455 723144 631284 786403 757245 680395 562953 567522 457321 484246 518643 556158 628730 437959 439476 544517 381890 433758 462649 487823 475305 531897 509631 572286 581938 769543 453078 438049 631571 391822 459289 486318 527293 535058 494658 501977 472065 558100 583100 552714 566920 586188 586997 624600 639157 746331 764958 726067 761150 710509 496115 636139 570878 549175 556093 718703 606792 768456 813298 518410 769245 626145 488851 421590 ] |
||||||||||||||||||||||||||||||
|
3.30 ms (2.19%) |
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 152973 172220 381890 391045 391822 397695 398579 400495 419344 421590 433758 437959 438032 438049 439476 449517 453078 454472 456416 457321 459289 462649 466758 472065 475305 484246 484281 486318 487823 488851 489778 489779 494658 495898 496115 496591 498171 500597 501977 504365 505949 507172 509631 514953 518410 518643 526122 527293 527352 531326 531897 535058 544517 545632 549175 550427 551570 552714 556093 556158 558100 562953 564670 566455 566920 567522 570878 571744 572286 574967 581938 583100 586188 586228 586997 589833 598420 606363 606792 619920 624015 624600 626145 628014 628730 631284 631571 636139 639157 670211 670251 680395 710509 718703 723144 724103 724790 725501 726067 728872 731167 736483 745980 746159 746331 746594 757245 761150 761216 764958 765934 768289 768456 769245 769543 777536 778989 786403 791101 813298 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"кончает на мужа"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм на жен"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.