Query Metrics
7
Database Queries
7
Different statements
154.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.05 ms (83.49%) |
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 338565 383791 398449 435356 460611 471715 485262 487359 489657 497703 501322 510413 512836 513394 514989 515953 518230 519325 528410 530066 532041 534735 544792 548274 555481 555847 556006 565028 574169 576774 577287 577813 579182 583790 591186 593978 599345 604301 604822 607518 610215 616505 620533 620909 622065 628801 629841 632147 636008 645349 647481 650728 656579 656634 656874 666403 674866 677569 679882 682639 683785 691514 695008 697561 698918 699166 700209 707617 710094 710468 713051 715888 723289 725286 726059 726820 728276 728360 734301 734326 734620 735022 746090 746569 758817 758896 761359 762380 763762 763922 767381 774251 775345 778372 781753 783108 785783 791698 792677 793627 794439 795247 797096 798799 801039 803648 804012 807521 808969 810974 812159 813002 817990 823844 823955 824049 824190 826153 826676 ] |
||||||||||||||||||||||||||||||
|
15.37 ms (9.95%) |
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 512836 510413 528410 514989 515953 579182 556006 607518 599345 519325 383791 398449 817990 823844 823955 826153 824190 460611 518230 555481 548274 576774 647481 656634 656874 683785 698918 699166 650728 677569 697561 713051 674866 695008 710468 723289 577813 632147 620909 636008 593978 610215 781753 783108 795247 775345 794439 807521 808969 812159 813002 734301 758817 767381 801039 803648 804012 734620 762380 728360 758896 763922 774251 726059 726820 734326 746569 761359 725286 728276 735022 746090 763762 629841 700209 715888 778372 783559 785783 791698 792677 797096 798799 810974 338565 497703 555847 604301 487359 485262 489657 682639 793627 707617 435356 513394 826676 824049 501322 532041 530066 534735 471715 544792 574169 565028 577287 656579 666403 645349 679882 710094 691514 583790 604822 616505 628801 591186 620533 622065 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.85%) |
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 338565 383791 398449 435356 460611 471715 485262 487359 489657 497703 501322 510413 512836 513394 514989 515953 518230 519325 528410 530066 532041 534735 544792 548274 555481 555847 556006 565028 574169 576774 577287 577813 579182 583790 591186 593978 599345 604301 604822 607518 610215 616505 620533 620909 622065 628801 629841 632147 636008 645349 647481 650728 656579 656634 656874 666403 674866 677569 679882 682639 683785 691514 695008 697561 698918 699166 700209 707617 710094 710468 713051 715888 723289 725286 726059 726820 728276 728360 734301 734326 734620 735022 746090 746569 758817 758896 761359 762380 763762 763922 767381 774251 775345 778372 781753 783108 785783 791698 792677 793627 794439 795247 797096 798799 801039 803648 804012 807521 808969 810974 812159 813002 817990 823844 823955 824049 824190 826153 826676 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ridding creampie"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"наездниц поз creampie"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"наездниц поз creampie"
]
|
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.