Query Metrics
7
Database Queries
7
Different statements
192.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.27 ms (84.21%) |
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 96393 187353 391344 391668 395714 397361 397881 400493 400807 400808 400813 401229 401307 409083 411322 412299 413182 413524 420886 421849 421995 422188 424325 428113 439521 439529 439591 439715 440598 443790 443791 445056 447808 449428 454890 465075 465902 465955 466198 466221 467034 468955 470196 470254 472148 474652 474678 481918 482575 483147 483149 483386 484558 484585 484678 484704 484705 484739 485267 485462 486253 488373 490904 493221 493224 494516 497700 505813 506529 509554 520681 526693 531070 534241 534316 534680 539951 541055 546947 546958 549848 550381 563074 567337 586910 589681 592462 596488 604018 618780 620201 624468 638557 678777 688071 696426 697758 710412 718496 745026 760313 770196 775989 782626 789670 790879 790882 792619 799146 803306 808063 810069 810337 810669 811037 815617 815865 817877 818206 820327 ] |
||||||||||||||||||||||||||||||
|
18.87 ms (9.79%) |
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 531070 490904 484678 439715 421995 482575 483149 484739 485267 534680 505813 509554 539951 466221 541055 546947 688071 567337 624468 589681 604018 618780 439521 391668 400807 465955 472148 474652 400808 401229 439591 470196 440598 454890 465075 493224 484558 484705 486253 494516 520681 187353 428113 815617 817877 820327 815865 818206 447808 534241 678777 696426 697758 710412 718496 638557 592462 596488 782626 790882 803306 808063 810669 770196 810069 810337 745026 620201 775989 789670 790879 811037 96393 409083 391344 400493 413182 497700 397361 397881 506529 550381 563074 546958 549848 799146 792619 413524 395714 421849 465902 400813 401307 412299 411322 422188 420886 466198 445056 485462 483147 488373 468955 534316 483386 586910 439529 443791 467034 424325 470254 449428 481918 443790 474678 493221 484585 484704 760313 526693 ] |
||||||||||||||||||||||||||||||
|
4.25 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 96393 187353 391344 391668 395714 397361 397881 400493 400807 400808 400813 401229 401307 409083 411322 412299 413182 413524 420886 421849 421995 422188 424325 428113 439521 439529 439591 439715 440598 443790 443791 445056 447808 449428 454890 465075 465902 465955 466198 466221 467034 468955 470196 470254 472148 474652 474678 481918 482575 483147 483149 483386 484558 484585 484678 484704 484705 484739 485267 485462 486253 488373 490904 493221 493224 494516 497700 505813 506529 509554 520681 526693 531070 534241 534316 534680 539951 541055 546947 546958 549848 550381 563074 567337 586910 589681 592462 596488 604018 618780 620201 624468 638557 678777 688071 696426 697758 710412 718496 745026 760313 770196 775989 782626 789670 790879 790882 792619 799146 803306 808063 810069 810337 810669 811037 815617 815865 817877 818206 820327 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old mature anal"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old mature анал"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old mature анал"
]
|
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.