Query Metrics
7
Database Queries
7
Different statements
196.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.83 ms (83.35%) |
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 400708 413889 421841 431514 441502 444908 446977 447078 449356 449398 453121 455245 455729 458172 459389 462991 463694 466165 466429 470330 471513 471831 474572 477239 478375 478978 479641 479644 481844 482785 484418 488120 490015 496554 498600 499826 504250 504684 506866 508128 510341 510591 510832 513155 513909 516087 516524 518820 519169 519460 520728 520870 521287 522121 522647 522839 523823 524029 524149 524203 524296 524344 525179 525261 525451 526513 526659 527243 527701 527885 528571 528711 528713 531446 533978 534320 542528 549990 554526 557164 557595 558210 558523 559008 559106 564636 564719 565167 565786 566323 567910 569835 574298 574416 574443 582035 582797 586485 588674 588802 593167 598553 600987 601103 603835 604038 607227 616237 617019 618972 620714 621312 622386 624833 626294 638303 643681 660834 670113 677973 ] |
||||||||||||||||||||||||||||||
|
22.00 ms (11.19%) |
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 513909 526659 482785 558523 559008 582797 564719 567910 574298 586485 588802 617019 616237 621312 449398 463694 466165 479644 470330 421841 447078 458172 459389 466429 441502 508128 516524 522839 521287 524344 525179 525261 526513 527885 504250 506866 510832 518820 519460 677973 582035 601103 431514 504684 400708 528711 527701 559106 565786 566323 603835 600987 471513 478375 510341 488120 542528 531446 593167 446977 574443 574416 496554 534320 565167 498600 474572 588674 598553 643681 549990 444908 618972 484418 490015 519169 520728 524296 513155 522647 523823 528713 527243 524203 558210 564636 670113 660834 557595 624833 607227 453121 479641 413889 477239 449356 471831 455729 462991 481844 524149 528571 525451 520870 522121 604038 620714 533978 569835 622386 455245 516087 499826 510591 557164 626294 638303 478978 524029 554526 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.37%) |
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 400708 413889 421841 431514 441502 444908 446977 447078 449356 449398 453121 455245 455729 458172 459389 462991 463694 466165 466429 470330 471513 471831 474572 477239 478375 478978 479641 479644 481844 482785 484418 488120 490015 496554 498600 499826 504250 504684 506866 508128 510341 510591 510832 513155 513909 516087 516524 518820 519169 519460 520728 520870 521287 522121 522647 522839 523823 524029 524149 524203 524296 524344 525179 525261 525451 526513 526659 527243 527701 527885 528571 528711 528713 531446 533978 534320 542528 549990 554526 557164 557595 558210 558523 559008 559106 564636 564719 565167 565786 566323 567910 569835 574298 574416 574443 582035 582797 586485 588674 588802 593167 598553 600987 601103 603835 604038 607227 616237 617019 618972 620714 621312 622386 624833 626294 638303 643681 660834 670113 677973 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass shorts"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп шорт"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.96%) |
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.