Query Metrics
7
Database Queries
7
Different statements
166.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.07 ms (82.14%) |
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 398958 401956 409113 415241 415846 422155 424873 425531 428814 430444 430828 433669 439214 439620 439621 439672 439730 439787 440614 443563 443737 445201 445393 446088 446299 450319 450336 450766 452297 453304 453438 455265 457856 460159 460924 461016 465356 466180 466757 468072 470031 475249 475263 477579 479144 481650 483001 483152 483417 484554 484562 484581 484653 484775 485271 486198 486536 486678 488074 489275 489471 489947 492298 496100 499883 503066 504411 504922 507047 508701 509164 509384 514295 517114 517240 519936 520407 520445 523141 524296 526008 526087 528089 531064 532022 532079 542969 543088 549650 549822 555182 556470 557499 560211 560512 561468 561478 561515 562964 565153 565659 572653 577491 578067 580913 582468 586980 588078 589574 591632 603852 613319 617040 621352 626367 667647 798684 807399 807953 808060 ] |
||||||||||||||||||||||||||||||
|
19.76 ms (11.84%) |
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 483152 499883 617040 621352 439620 443737 445201 422155 468072 514295 520407 484653 486678 520445 532022 439621 439672 439730 555182 582468 509164 486536 443563 450336 453304 457856 450319 509384 517114 531064 532079 484775 488074 489947 542969 549650 561468 556470 557499 560512 572653 543088 549822 562964 578067 603852 591632 586980 808060 466180 475263 428814 445393 479144 460924 465356 466757 452297 470031 450766 477579 517240 526008 484562 485271 489471 503066 519936 561515 430828 484581 483417 496100 486198 589574 475249 430444 484554 528089 401956 492298 415241 424873 455265 461016 523141 524296 508701 483001 580913 565659 667647 560211 626367 588078 613319 807953 807399 798684 433669 415846 440614 439214 481650 439787 489275 526087 507047 561478 565153 504922 504411 425531 409113 446299 446088 460159 398958 453438 577491 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.74%) |
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 398958 401956 409113 415241 415846 422155 424873 425531 428814 430444 430828 433669 439214 439620 439621 439672 439730 439787 440614 443563 443737 445201 445393 446088 446299 450319 450336 450766 452297 453304 453438 455265 457856 460159 460924 461016 465356 466180 466757 468072 470031 475249 475263 477579 479144 481650 483001 483152 483417 484554 484562 484581 484653 484775 485271 486198 486536 486678 488074 489275 489471 489947 492298 496100 499883 503066 504411 504922 507047 508701 509164 509384 514295 517114 517240 519936 520407 520445 523141 524296 526008 526087 528089 531064 532022 532079 542969 543088 549650 549822 555182 556470 557499 560211 560512 561468 561478 561515 562964 565153 565659 572653 577491 578067 580913 582468 586980 588078 589574 591632 603852 613319 617040 621352 626367 667647 798684 807399 807953 808060 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf boy sleep"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf парен спящ"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf парен спящ"
]
|
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.