Query Metrics
7
Database Queries
7
Different statements
151.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.61 ms (83.99%) |
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 414078 417241 418426 418739 422280 426484 426821 428580 432545 433364 441666 441957 442458 442896 443896 445288 445670 446715 451213 451525 453191 455693 456863 457546 458364 458370 458985 460305 460593 463204 476313 481101 486046 503079 508210 512422 517500 517699 517883 529419 531380 539332 541012 543689 543958 544536 549679 550788 560869 563768 569298 579542 592614 594018 594204 594235 602712 607440 610286 628837 630394 630724 634930 637905 641101 641180 648183 656219 657755 660292 664150 664275 680290 697004 697170 697207 698128 707616 711616 728548 728619 744419 747056 749652 753059 753060 753779 764101 765489 773229 781899 784961 788439 789008 789503 793605 794179 794836 794857 794858 797347 797349 797354 800256 800921 801316 801399 802274 804667 804725 809282 810114 812408 819401 819730 824221 824690 826639 826659 ] |
||||||||||||||||||||||||||||||
|
13.69 ms (9.01%) |
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 543689 664275 550788 607440 628837 594204 594235 630724 793605 800256 804667 773229 784830 794857 728619 744419 753059 765489 749652 602712 784961 801316 804725 432545 451525 422280 503079 812408 747056 764101 543958 657755 711616 648183 426484 417241 539332 531380 544536 697170 664150 697004 634930 592614 594018 442896 414078 458985 441957 418739 428580 445288 819401 826659 826639 824690 824221 819730 451213 457546 476313 508210 512422 529419 481101 563768 541012 697207 698128 610286 788439 797347 797349 728548 781899 794836 794858 800921 789008 789503 794179 797354 801399 802274 809282 463204 426821 455693 517500 442458 460305 660292 680290 579542 630394 641180 517883 656219 641101 753060 810114 753779 707616 569298 637905 560869 549679 443896 418426 433364 441666 446715 456863 486046 445670 458370 453191 458364 460593 517699 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (2.07%) |
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 414078 417241 418426 418739 422280 426484 426821 428580 432545 433364 441666 441957 442458 442896 443896 445288 445670 446715 451213 451525 453191 455693 456863 457546 458364 458370 458985 460305 460593 463204 476313 481101 486046 503079 508210 512422 517500 517699 517883 529419 531380 539332 541012 543689 543958 544536 549679 550788 560869 563768 569298 579542 592614 594018 594204 594235 602712 607440 610286 628837 630394 630724 634930 637905 641101 641180 648183 656219 657755 660292 664150 664275 680290 697004 697170 697207 698128 707616 711616 728548 728619 744419 747056 749652 753059 753060 753779 764101 765489 773229 781899 784961 788439 789008 789503 793605 794179 794836 794857 794858 797347 797349 797354 800256 800921 801316 801399 802274 804667 804725 809282 810114 812408 819401 819730 824221 824690 826639 826659 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"chubby amateur pov"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"chubby любительск пов"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"chubby любительск пов"
]
|
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.