Query Metrics
7
Database Queries
7
Different statements
149.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.75 ms (80.86%) |
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 88174 88942 89347 181926 182033 182118 182206 182227 182352 182526 183074 275727 357499 381812 382041 382281 382298 382390 385955 386028 386232 386325 387293 388183 392421 398078 401767 402634 410242 410702 413446 414048 414064 414090 414241 414662 415294 415857 416711 418112 418117 418139 418146 419439 420394 422101 423651 423662 429596 429602 430347 434314 434315 434326 434336 434338 434339 434344 435403 439125 439171 439931 443240 443243 443276 449022 449023 457816 460813 462231 470428 476662 476704 482293 483741 486778 493258 493839 500897 518191 522169 522171 524066 526473 550887 582579 588717 599502 613530 623284 666475 701303 705454 713332 728039 736872 736990 738486 738506 746131 755942 756138 761632 776059 782462 791165 791890 791922 791928 792146 800522 800540 800542 800698 800733 805548 807009 808331 808842 827619 ] |
||||||||||||||||||||||||||||||
|
17.83 ms (11.94%) |
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 807009 800542 761632 800733 182526 457816 483741 88942 385955 392421 401767 430347 413446 418146 414662 416711 423651 434326 410702 420394 500897 524066 582579 599502 588717 808842 738506 713332 800522 800698 443276 357499 418117 434315 462231 386028 388183 422101 434344 435403 522171 182227 746131 382281 386232 381812 387293 402634 414090 429602 434339 434314 449022 470428 522169 666475 623284 808331 439125 183074 460813 526473 382041 827619 791922 736990 182206 182118 418112 434336 439171 414064 418139 414048 423662 429596 449023 550887 613530 776059 410242 482293 415294 415857 434338 443240 493258 493839 182033 275727 382390 476662 791890 792146 791165 805548 89347 414241 181926 382298 88174 398078 486778 476704 701303 791928 800540 755942 756138 782462 728039 736872 738486 705454 182352 386325 443243 419439 439931 518191 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (2.20%) |
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 88174 88942 89347 181926 182033 182118 182206 182227 182352 182526 183074 275727 357499 381812 382041 382281 382298 382390 385955 386028 386232 386325 387293 388183 392421 398078 401767 402634 410242 410702 413446 414048 414064 414090 414241 414662 415294 415857 416711 418112 418117 418139 418146 419439 420394 422101 423651 423662 429596 429602 430347 434314 434315 434326 434336 434338 434339 434344 435403 439125 439171 439931 443240 443243 443276 449022 449023 457816 460813 462231 470428 476662 476704 482293 483741 486778 493258 493839 500897 518191 522169 522171 524066 526473 550887 582579 588717 599502 613530 623284 666475 701303 705454 713332 728039 736872 736990 738486 738506 746131 755942 756138 761632 776059 782462 791165 791890 791922 791928 792146 800522 800540 800542 800698 800733 805548 807009 808331 808842 827619 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexmachine"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сексмашин"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.