Query Metrics
7
Database Queries
7
Different statements
176.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.61 ms (82.73%) |
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 193666 414157 414184 416365 416886 420635 421871 428126 434322 434364 434374 441004 443790 445728 467878 468072 475957 476055 479661 489424 491463 492364 495647 497665 497866 508133 509024 511376 512561 513568 515776 517008 517012 521586 521992 524804 532804 533011 533773 534988 535054 535456 537196 537654 537671 540944 541699 541725 541749 541781 541806 542190 543576 543852 544477 544478 544627 544637 544668 546200 549799 552623 556029 556421 556885 559162 559183 561136 566079 566503 567909 569042 571028 571434 574464 576536 576604 576711 576895 577349 583700 584006 585744 587035 590857 591896 592046 592541 593863 593868 593877 599862 599863 599908 599914 599922 599934 599955 599961 599976 600019 600171 600256 601040 601585 603247 603773 607071 607230 613177 615716 619811 624776 634774 636295 642315 647964 650155 734038 796853 ] |
||||||||||||||||||||||||||||||
|
20.35 ms (11.56%) |
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 434322 443790 556885 571028 541749 546200 593868 599863 599961 600019 567909 193666 445728 509024 532804 537671 537196 517012 533011 476055 479661 540944 541725 542190 543576 544477 556421 574464 541781 647964 569042 576604 599934 601585 607071 600256 642315 587035 599908 734038 414184 434374 434364 513568 491463 511376 552623 524804 619811 489424 592046 650155 559183 591896 624776 420635 441004 534988 533773 544627 544668 584006 599976 600171 599955 585744 599862 615716 636295 613177 541699 521992 515776 475957 590857 603773 492364 495647 508133 521586 535054 537654 541806 543852 559162 576895 577349 556029 566503 571434 544637 549799 561136 576711 601040 592541 593877 599914 593863 603247 467878 468072 497665 535456 497866 512561 428126 583700 634774 599922 607230 421871 566079 544478 416886 517008 576536 796853 414157 416365 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.65%) |
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 193666 414157 414184 416365 416886 420635 421871 428126 434322 434364 434374 441004 443790 445728 467878 468072 475957 476055 479661 489424 491463 492364 495647 497665 497866 508133 509024 511376 512561 513568 515776 517008 517012 521586 521992 524804 532804 533011 533773 534988 535054 535456 537196 537654 537671 540944 541699 541725 541749 541781 541806 542190 543576 543852 544477 544478 544627 544637 544668 546200 549799 552623 556029 556421 556885 559162 559183 561136 566079 566503 567909 569042 571028 571434 574464 576536 576604 576711 576895 577349 583700 584006 585744 587035 590857 591896 592046 592541 593863 593868 593877 599862 599863 599908 599914 599922 599934 599955 599961 599976 600019 600171 600256 601040 601585 603247 603773 607071 607230 613177 615716 619811 624776 634774 636295 642315 647964 650155 734038 796853 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые анал milf"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny anal milf"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые анал milf"
]
|
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.