Query Metrics
7
Database Queries
7
Different statements
150.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.06 ms (82.24%) |
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 391923 398599 401071 409251 416832 418138 429355 431234 431568 432358 432939 434106 436942 442296 444117 448328 450262 452353 457294 457992 460196 461944 462196 464364 464667 465431 466995 466999 467905 468159 468228 468300 470007 470015 471194 473132 473634 475296 476932 479923 487008 489537 494598 496840 510280 510905 510943 513619 517398 517508 518897 523382 523595 525446 528966 531804 532920 533922 542285 545913 552569 561967 562159 564475 578148 578737 578770 580852 581597 586441 586903 588549 589685 590370 593406 594136 594143 594283 594340 595049 599668 601695 604804 604842 605145 607401 607906 609047 618069 618302 618619 629602 629912 642928 650666 660434 664236 664579 666032 668952 706889 710447 714698 738477 746122 749064 751432 751511 752840 752940 759146 781786 786687 787867 804159 804421 807028 808319 812531 812553 ] |
||||||||||||||||||||||||||||||
|
16.17 ms (10.72%) |
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 448328 462196 470007 518897 666032 475296 487008 589685 466995 461944 513619 510280 431568 517508 605145 607906 807028 391923 457294 465431 470015 586903 429355 432939 468228 450262 457992 460196 464364 476932 525446 523595 533922 510905 523382 561967 542285 552569 664236 578148 581597 594340 594143 752940 812531 751432 787867 473132 473634 479923 398599 452353 464667 436942 494598 531804 618619 471194 489537 601695 467905 418138 444117 416832 409251 434106 468300 496840 510943 528966 532920 517398 466999 562159 564475 580852 545913 578737 668952 706889 650666 714698 660434 664579 710447 578770 590370 599668 629912 588549 593406 609047 629602 586441 604804 618302 594136 594283 595049 604842 607401 642928 786687 804421 746122 749064 781786 808319 812553 751511 759146 738477 752840 618069 804159 401071 432358 468159 431234 442296 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.87%) |
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 391923 398599 401071 409251 416832 418138 429355 431234 431568 432358 432939 434106 436942 442296 444117 448328 450262 452353 457294 457992 460196 461944 462196 464364 464667 465431 466995 466999 467905 468159 468228 468300 470007 470015 471194 473132 473634 475296 476932 479923 487008 489537 494598 496840 510280 510905 510943 513619 517398 517508 518897 523382 523595 525446 528966 531804 532920 533922 542285 545913 552569 561967 562159 564475 578148 578737 578770 580852 581597 586441 586903 588549 589685 590370 593406 594136 594143 594283 594340 595049 599668 601695 604804 604842 605145 607401 607906 609047 618069 618302 618619 629602 629912 642928 650666 660434 664236 664579 666032 668952 706889 710447 714698 738477 746122 749064 751432 751511 752840 752940 759146 781786 786687 787867 804159 804421 807028 808319 812531 812553 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy ass solo"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая жоп соло"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.18%) |
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.