Query Metrics
7
Database Queries
7
Different statements
153.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.81 ms (85.98%) |
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 472312 476476 519246 519251 519266 522914 538817 538930 539516 539610 539649 541402 541419 542488 544263 544264 544267 544272 544276 544312 544321 544577 544589 549911 550321 551078 553278 556777 560087 560920 563099 563383 563452 564286 566860 567430 571434 572545 574405 576644 576645 576711 576712 576713 581270 581278 581284 581353 582760 583581 583837 583861 587819 589739 590932 592428 592435 592457 592461 592474 592481 592501 592513 592541 592543 602665 604977 606417 612945 614321 621703 621715 622354 622954 624153 628297 628326 644261 644953 646942 648963 649989 651210 662397 670111 671732 671758 672105 672118 672184 673531 684030 690774 690874 692303 692813 693029 694195 694207 695204 696271 699540 699698 703109 703437 710317 716590 718518 719107 719132 719140 720647 721755 727685 730225 733539 742911 750060 750064 819508 ] |
||||||||||||||||||||||||||||||
|
11.68 ms (7.62%) |
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 719140 539649 544264 592474 576644 581270 592513 720647 628326 592461 581353 519266 612945 574405 544263 563099 583861 592457 592481 544589 694195 624153 583837 583581 576712 750060 581284 690874 692303 693029 696271 621703 622954 544312 544321 538817 472312 644953 692813 699698 695204 621715 592428 614321 742911 581278 544577 721755 519251 544272 560087 690774 719132 673531 699540 671732 563452 592543 727685 733539 718518 539610 564286 544267 567430 703109 519246 750064 476476 576711 549911 539516 538930 556777 541402 710317 670111 672105 606417 622354 628297 703437 684030 648963 563383 553278 542488 649989 662397 522914 576713 571434 576645 592541 550321 730225 819508 572545 671758 719107 672118 672184 716590 694207 587819 644261 589739 604977 544276 582760 646942 592501 590932 566860 651210 560920 592435 541419 551078 602665 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.92%) |
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 472312 476476 519246 519251 519266 522914 538817 538930 539516 539610 539649 541402 541419 542488 544263 544264 544267 544272 544276 544312 544321 544577 544589 549911 550321 551078 553278 556777 560087 560920 563099 563383 563452 564286 566860 567430 571434 572545 574405 576644 576645 576711 576712 576713 581270 581278 581284 581353 582760 583581 583837 583861 587819 589739 590932 592428 592435 592457 592461 592474 592481 592501 592513 592541 592543 602665 604977 606417 612945 614321 621703 621715 622354 622954 624153 628297 628326 644261 644953 646942 648963 649989 651210 662397 670111 671732 671758 672105 672118 672184 673531 684030 690774 690874 692303 692813 693029 694195 694207 695204 696271 699540 699698 703109 703437 710317 716590 718518 719107 719132 719140 720647 721755 727685 730225 733539 742911 750060 750064 819508 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vintage mom sperm"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"vintage mom сперм"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"vintage mom сперм"
]
|
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.