Query Metrics
7
Database Queries
7
Different statements
167.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.36 ms (83.72%) |
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 385092 390629 416296 416606 417087 419196 421379 422028 424330 424671 424696 424871 424884 425851 427843 430144 430479 435468 435573 438272 440937 441647 442857 442943 446179 446918 447587 449635 449743 449757 449778 449829 454991 455565 455767 459110 459676 460062 463990 466666 468644 469326 472615 473009 473020 473045 473589 474712 475003 476678 476691 479570 481877 482674 483124 484324 485785 486957 489434 490063 496940 497643 505999 506359 507865 515728 515851 516086 519034 519038 523321 523936 524535 527719 528173 533192 533261 539441 542971 546214 575169 593849 595357 595756 599504 602724 610228 616973 617124 622054 626866 626960 632013 634242 639975 641852 675726 706497 747259 748231 756807 764253 770708 775466 776969 782646 784080 789046 792343 795138 797880 799063 799261 804721 807187 808210 813750 814665 821145 823531 ] |
||||||||||||||||||||||||||||||
|
16.96 ms (10.11%) |
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 595357 616973 617124 626866 641852 602724 639975 599504 610228 622054 632013 634242 776969 789046 792343 775466 799063 808210 756807 784080 797880 799261 748231 764253 626960 706497 795138 807187 416296 419196 424696 469326 473009 479570 463990 468644 425851 442857 473045 475003 427843 435468 435573 442943 446179 449829 459676 466666 506359 483124 486957 496940 515728 484324 485785 497643 515851 516086 539441 523321 523936 527719 804721 747259 482674 455767 575169 519038 528173 770708 385092 390629 424884 473020 460062 505999 449635 524535 542971 593849 595756 449778 422028 490063 813750 533192 533261 546214 782646 675726 447587 519034 473589 421379 441647 424330 424671 430479 416606 424871 430144 438272 417087 440937 821145 823531 814665 449757 474712 476678 489434 446918 449743 459110 481877 454991 455565 472615 476691 507865 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov pussy lick"
]
|
||||||||||||||||||||||||||||||
|
2.36 ms (1.41%) |
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 385092 390629 416296 416606 417087 419196 421379 422028 424330 424671 424696 424871 424884 425851 427843 430144 430479 435468 435573 438272 440937 441647 442857 442943 446179 446918 447587 449635 449743 449757 449778 449829 454991 455565 455767 459110 459676 460062 463990 466666 468644 469326 472615 473009 473020 473045 473589 474712 475003 476678 476691 479570 481877 482674 483124 484324 485785 486957 489434 490063 496940 497643 505999 506359 507865 515728 515851 516086 519034 519038 523321 523936 524535 527719 528173 533192 533261 539441 542971 546214 575169 593849 595357 595756 599504 602724 610228 616973 617124 622054 626866 626960 632013 634242 639975 641852 675726 706497 747259 748231 756807 764253 770708 775466 776969 782646 784080 789046 792343 795138 797880 799063 799261 804721 807187 808210 813750 814665 821145 823531 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов pussy лиза"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов pussy лиза"
]
|
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.