Query Metrics
7
Database Queries
7
Different statements
161.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.72 ms (85.44%) |
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 68412 118008 185212 185950 382014 401479 410702 416652 416731 416738 417561 418146 419188 420217 420394 420864 422635 422713 423933 426052 427745 428220 428305 428308 429518 429961 430347 434320 434326 434327 434332 434527 435510 435563 435591 438957 439393 441057 441063 441952 443084 443152 443309 443861 445787 445948 446049 446966 448057 448551 450278 450279 450367 452362 452809 452818 452822 452826 453997 456700 457995 464844 465454 466991 468244 468813 473103 473213 473450 476646 477052 479669 480428 487429 493688 494826 500250 500263 500897 502789 504562 505143 506115 508177 508935 510541 511937 513245 513805 514085 517509 517846 518891 525970 529897 532749 532830 534530 534542 534551 534552 535438 536062 536224 536226 540531 552113 571997 584021 588514 596478 598834 640948 678707 791492 813899 814411 816270 817271 823607 ] |
||||||||||||||||||||||||||||||
|
14.21 ms (8.82%) |
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 438957 445948 468244 517846 401479 480428 640948 452826 450367 185212 382014 416731 416652 429518 434320 410702 450279 452818 445787 476646 504562 500897 511937 536062 508177 552113 571997 678707 588514 791492 434332 468813 435510 452362 422635 428305 434327 435591 510541 435563 584021 596478 598834 473103 118008 185950 68412 419188 426052 430347 441952 418146 420217 422713 427745 434527 443309 416738 429961 439393 441057 443084 417561 423933 428220 434326 441063 443152 443861 420394 420864 428308 817271 814411 816270 813899 823607 448057 448551 450278 453997 464844 477052 487429 493688 446049 446966 456700 457995 473450 452809 452822 465454 466991 473213 479669 502789 513805 518891 532830 534530 536226 494826 500250 500263 514085 517509 525970 532749 534551 505143 513245 529897 534542 534552 535438 536224 540531 506115 508935 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.54%) |
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 68412 118008 185212 185950 382014 401479 410702 416652 416731 416738 417561 418146 419188 420217 420394 420864 422635 422713 423933 426052 427745 428220 428305 428308 429518 429961 430347 434320 434326 434327 434332 434527 435510 435563 435591 438957 439393 441057 441063 441952 443084 443152 443309 443861 445787 445948 446049 446966 448057 448551 450278 450279 450367 452362 452809 452818 452822 452826 453997 456700 457995 464844 465454 466991 468244 468813 473103 473213 473450 476646 477052 479669 480428 487429 493688 494826 500250 500263 500897 502789 504562 505143 506115 508177 508935 510541 511937 513245 513805 514085 517509 517846 518891 525970 529897 532749 532830 534530 534542 534551 534552 535438 536062 536224 536226 540531 552113 571997 584021 588514 596478 598834 640948 678707 791492 813899 814411 816270 817271 823607 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"oil masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"масл мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.95%) |
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.