Query Metrics
7
Database Queries
7
Different statements
171.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.95 ms (83.37%) |
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 142471 387798 391693 393442 396458 396748 397071 399475 409015 412506 413106 414101 414760 417770 417813 417975 419428 422054 422318 424159 429040 429066 429071 429182 429286 429299 429611 431139 431541 444726 445567 450269 453198 461585 464625 470301 475143 475343 477211 478464 482730 485196 486766 489009 489523 490205 490592 491192 491199 491205 491776 493876 502991 503003 510214 512242 518917 524207 525842 528970 540876 541195 545456 548058 551189 551203 555791 558042 558307 559097 560186 561392 561656 561672 561684 561718 564459 565044 565053 568299 570711 572427 572498 573384 573857 576728 581961 588116 597051 598451 602633 604350 605850 612476 620256 622510 627378 651151 651808 653243 660613 663232 665867 666662 667672 681216 682865 685767 689212 692998 696460 708505 721006 744095 745075 750471 757151 791975 810965 827829 ] |
||||||||||||||||||||||||||||||
|
16.95 ms (9.89%) |
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 757151 744095 721006 665867 681216 667672 605850 598451 620256 417813 827829 528970 548058 568299 572498 565053 545456 685767 692998 561718 576728 597051 750471 414760 445567 396458 397071 399475 409015 422054 461585 490205 512242 489523 482730 558307 602633 470301 431541 475143 477211 490592 491776 142471 424159 510214 525842 502991 503003 429611 486766 572427 570711 561656 663232 573857 604350 791975 745075 478464 429299 524207 485196 491199 491192 491205 518917 419428 387798 422318 429066 450269 682865 689212 708505 651151 666662 696460 588116 612476 622510 627378 810965 417770 475343 431139 393442 391693 396748 417975 429040 429182 429071 429286 414101 412506 413106 444726 540876 489009 453198 464625 493876 551203 558042 561672 573384 551189 564459 541195 555791 561392 565044 581961 651808 653243 660613 559097 560186 561684 ] |
||||||||||||||||||||||||||||||
|
3.89 ms (2.27%) |
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 142471 387798 391693 393442 396458 396748 397071 399475 409015 412506 413106 414101 414760 417770 417813 417975 419428 422054 422318 424159 429040 429066 429071 429182 429286 429299 429611 431139 431541 444726 445567 450269 453198 461585 464625 470301 475143 475343 477211 478464 482730 485196 486766 489009 489523 490205 490592 491192 491199 491205 491776 493876 502991 503003 510214 512242 518917 524207 525842 528970 540876 541195 545456 548058 551189 551203 555791 558042 558307 559097 560186 561392 561656 561672 561684 561718 564459 565044 565053 568299 570711 572427 572498 573384 573857 576728 581961 588116 597051 598451 602633 604350 605850 612476 620256 622510 627378 651151 651808 653243 660613 663232 665867 666662 667672 681216 682865 685767 689212 692998 696460 708505 721006 744095 745075 750471 757151 791975 810965 827829 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"18 skinny blonde"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"18 худые беловолосая"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"18 худые беловолосая"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.