Query Metrics
7
Database Queries
7
Different statements
175.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.24 ms (84.94%) |
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 410694 411984 419949 420599 427082 428024 432706 442542 443978 447755 450228 454341 454540 456287 456572 458106 458794 461594 465406 466286 469568 469695 470088 472691 472990 473973 474433 474942 476902 477044 477296 477395 479258 479549 479572 482713 484621 486506 487716 487796 488877 490768 491749 493268 497005 497619 500362 500643 504358 504574 507811 508072 511684 512165 513342 513435 513705 516389 517180 519819 520071 520885 522791 524173 524399 524565 525351 525600 527314 528568 528855 533024 541417 542946 545645 546697 546901 547936 548224 556920 558656 559087 562951 563055 564805 565511 565580 566226 566284 567371 568174 569408 573587 575189 578388 582205 582335 582352 589288 589304 592730 597452 603175 612066 615819 618565 620059 630576 635687 659181 661409 668380 673957 703494 714840 715520 716072 758969 794956 795000 ] |
||||||||||||||||||||||||||||||
|
15.30 ms (8.71%) |
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 411984 428024 461594 466286 487796 517180 497005 504574 508072 524565 528855 504358 542946 556920 582205 589304 597452 589288 592730 630576 635687 470088 469695 458106 490768 487716 512165 527314 447755 458794 497619 558656 567371 564805 703494 546901 565580 618565 620059 795000 716072 794956 420599 443978 472691 419949 500643 491749 524399 758969 500362 524173 473973 476902 432706 410694 525351 582335 479549 472990 547936 575189 578388 673957 612066 427082 520885 533024 488877 573587 668380 582352 603175 456287 477044 516389 522791 482713 454341 477296 519819 565511 659181 559087 615819 479572 456572 486506 442542 493268 513342 511684 520071 513435 528568 563055 566284 545645 568174 715520 474942 474433 479258 546697 569408 548224 661409 714840 566226 469568 450228 465406 507811 513705 525600 484621 454540 477395 541417 562951 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.84%) |
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 410694 411984 419949 420599 427082 428024 432706 442542 443978 447755 450228 454341 454540 456287 456572 458106 458794 461594 465406 466286 469568 469695 470088 472691 472990 473973 474433 474942 476902 477044 477296 477395 479258 479549 479572 482713 484621 486506 487716 487796 488877 490768 491749 493268 497005 497619 500362 500643 504358 504574 507811 508072 511684 512165 513342 513435 513705 516389 517180 519819 520071 520885 522791 524173 524399 524565 525351 525600 527314 528568 528855 533024 541417 542946 545645 546697 546901 547936 548224 556920 558656 559087 562951 563055 564805 565511 565580 566226 566284 567371 568174 569408 573587 575189 578388 582205 582335 582352 589288 589304 592730 597452 603175 612066 615819 618565 620059 630576 635687 659181 661409 668380 673957 703494 714840 715520 716072 758969 794956 795000 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс ноч"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"трахнула ночью"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс ноч"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.11%) |
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.