Query Metrics
7
Database Queries
7
Different statements
208.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.13 ms (88.59%) |
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 118098 390950 392007 411201 414595 424614 424658 426220 427289 428174 429879 430709 433318 433477 433990 434337 441129 443819 445930 446639 446856 448871 450187 452526 452797 453157 453409 454270 460015 467893 469527 471995 472438 473185 473223 474103 478445 481151 493150 494231 495126 495507 497693 505382 507284 511375 512355 518147 526195 530500 531183 534546 535038 537922 538925 541226 542802 545325 545328 548277 549228 555199 555225 555243 555252 555267 555279 555297 555396 555435 558132 559324 570394 576607 579701 581126 581937 583501 583541 590370 590879 590949 592996 598298 599557 609071 614858 623510 629428 634071 639335 639789 642022 646880 660422 686712 688105 690831 692237 693872 695096 697364 706935 707416 720047 725583 728345 748695 749064 755930 765724 766911 770514 777063 789844 802357 812229 819238 820953 823368 ] |
||||||||||||||||||||||||||||||
|
13.67 ms (6.54%) |
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 497693 555243 545325 555225 555279 576607 555252 453409 411201 538925 697364 695096 693872 555267 590370 749064 770514 460015 426220 433477 469527 505382 555297 581126 555199 558132 599557 446639 494231 390950 424658 609071 427289 706935 433990 549228 583501 583541 548277 590949 495507 511375 707416 445930 429879 614858 453157 118098 512355 765724 481151 392007 467893 526195 720047 755930 428174 446856 452797 530500 531183 570394 692237 642022 592996 639789 454270 441129 634071 629428 452526 443819 430709 433318 581937 495126 518147 424614 450187 473185 474103 448871 555396 542802 545328 802357 471995 472438 414595 819238 820953 823368 493150 478445 534546 541226 646880 688105 686712 812229 789844 728345 748695 623510 777063 434337 537922 559324 555435 690831 660422 639335 590879 598298 725583 766911 507284 535038 579701 473223 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.42%) |
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 118098 390950 392007 411201 414595 424614 424658 426220 427289 428174 429879 430709 433318 433477 433990 434337 441129 443819 445930 446639 446856 448871 450187 452526 452797 453157 453409 454270 460015 467893 469527 471995 472438 473185 473223 474103 478445 481151 493150 494231 495126 495507 497693 505382 507284 511375 512355 518147 526195 530500 531183 534546 535038 537922 538925 541226 542802 545325 545328 548277 549228 555199 555225 555243 555252 555267 555279 555297 555396 555435 558132 559324 570394 576607 579701 581126 581937 583501 583541 590370 590879 590949 592996 598298 599557 609071 614858 623510 629428 634071 639335 639789 642022 646880 660422 686712 688105 690831 692237 693872 695096 697364 706935 707416 720047 725583 728345 748695 749064 755930 765724 766911 770514 777063 789844 802357 812229 819238 820953 823368 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal gape hairy"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал большая большие дырк волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.75%) |
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.