Query Metrics
7
Database Queries
7
Different statements
165.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.20 ms (86.17%) |
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 402999 421618 423463 426393 426627 433751 433939 438590 441770 442421 452534 456290 459963 465123 472874 476889 483570 495097 525296 529664 534132 534763 538169 545731 549577 556075 559472 559474 569262 573929 577253 588221 592946 593725 594111 607417 607850 627778 633917 636889 647043 659247 670210 675393 690304 701267 705175 706475 708182 708655 708674 709880 714090 714104 714890 716529 720193 722437 722543 724372 724677 724898 726393 729134 734400 736967 747873 750951 751728 752615 752921 752960 757955 760597 761076 762912 763145 764020 764947 765211 765941 768462 768497 769779 770342 770358 770361 770378 772026 772650 775537 776161 781280 782828 782877 783617 783996 785731 785816 786823 786986 788521 788662 791133 791851 793395 793586 796873 797088 797773 797878 800532 801033 801078 802870 806936 823787 825442 826609 ] |
||||||||||||||||||||||||||||||
|
13.13 ms (7.96%) |
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 775537 793395 797878 729134 782877 783617 785731 788662 802870 724677 747873 765941 768497 772026 726393 734400 751728 724372 762912 764020 752960 770342 559472 559474 495097 549577 423463 438590 826609 465123 569262 647043 714890 722437 556075 607417 607850 785816 806936 760597 763145 781280 791133 797773 800532 801033 761893 770361 765211 770358 770378 797088 433751 472874 476889 534763 529664 538169 690304 714090 701267 705175 706475 708674 659247 675393 633917 592946 593725 588221 594111 708182 709880 426627 534132 402999 441770 426393 823787 825442 456290 452534 545731 722543 720193 670210 627778 636889 776161 783996 791851 786823 724898 736967 750951 752921 772650 793586 801078 764947 752615 768462 769779 757955 788521 483570 573929 433939 577253 761076 525296 708655 421618 442421 459963 714104 716529 782828 786986 796873 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.88%) |
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 402999 421618 423463 426393 426627 433751 433939 438590 441770 442421 452534 456290 459963 465123 472874 476889 483570 495097 525296 529664 534132 534763 538169 545731 549577 556075 559472 559474 569262 573929 577253 588221 592946 593725 594111 607417 607850 627778 633917 636889 647043 659247 670210 675393 690304 701267 705175 706475 708182 708655 708674 709880 714090 714104 714890 716529 720193 722437 722543 724372 724677 724898 726393 729134 734400 736967 747873 750951 751728 752615 752921 752960 757955 760597 761076 762912 763145 764020 764947 765211 765941 768462 768497 769779 770342 770358 770361 770378 772026 772650 775537 776161 781280 782828 782877 783617 783996 785731 785816 786823 786986 788521 788662 791133 791851 793395 793586 796873 797088 797773 797878 800532 801033 801078 802870 806936 823787 825442 826609 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade little"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск little"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск little"
]
|
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.