Query Metrics
7
Database Queries
7
Different statements
429.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.22 ms (49.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд маленькая"
]
|
||||||||||||||||||||||||||||||
|
192.27 ms (44.80%) |
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 88115 382275 384509 403215 415294 416614 419571 420864 427292 428750 432933 432970 435567 439151 444187 448854 449586 449687 450020 450518 450969 457214 467873 467882 467893 471153 473038 475420 489331 493688 495208 497693 498473 505139 510729 522145 529034 544001 544829 546972 547468 547474 547480 547482 548153 550049 551589 551623 552069 556343 556425 560299 561015 561034 561040 561976 564227 564463 566035 566083 569258 569779 573204 575941 578328 580379 582072 582303 584337 590908 594267 600071 602212 602291 604855 607296 609890 630091 630420 640262 648859 648869 650316 656905 656913 660382 660412 660416 660419 661455 679093 683023 692943 693310 694619 695870 697614 713194 713196 731448 741557 751438 754136 755422 766415 769885 770397 777849 778695 784217 785584 788118 791382 791388 798291 801627 810852 811570 823353 823484 ] |
||||||||||||||||||||||||||||||
|
16.67 ms (3.88%) |
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 547480 548153 561034 683023 648869 660412 660419 660382 788118 810852 766415 550049 569779 467882 467893 427292 457214 449586 450518 498473 471153 584337 403215 467873 428750 444187 449687 648859 656913 823353 420864 493688 473038 497693 544829 582072 546972 551623 544001 566083 580379 556425 755422 382275 510729 823484 522145 551589 713196 661455 679093 697614 713194 656905 602291 604855 640262 777849 784217 801627 778695 731448 751438 769885 785584 741557 791382 791388 811570 88115 650316 432970 569258 566035 590908 600071 448854 552069 609890 630091 439151 416614 384509 435567 450020 754136 419571 450969 475420 505139 547482 564463 573204 564227 547468 547474 695870 660416 561015 561040 602212 630420 770397 798291 415294 432933 529034 489331 561976 495208 560299 556343 582303 578328 692943 693310 694619 575941 607296 594267 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (0.66%) |
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 88115 382275 384509 403215 415294 416614 419571 420864 427292 428750 432933 432970 435567 439151 444187 448854 449586 449687 450020 450518 450969 457214 467873 467882 467893 471153 473038 475420 489331 493688 495208 497693 498473 505139 510729 522145 529034 544001 544829 546972 547468 547474 547480 547482 548153 550049 551589 551623 552069 556343 556425 560299 561015 561034 561040 561976 564227 564463 566035 566083 569258 569779 573204 575941 578328 580379 582072 582303 584337 590908 594267 600071 602212 602291 604855 607296 609890 630091 630420 640262 648859 648869 650316 656905 656913 660382 660412 660416 660419 661455 679093 683023 692943 693310 694619 695870 697614 713194 713196 731448 741557 751438 754136 755422 766415 769885 770397 777849 778695 784217 785584 788118 791382 791388 798291 801627 810852 811570 823353 823484 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд маленькая"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo small"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.39%) |
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.