Query Metrics
7
Database Queries
7
Different statements
178.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.96 ms (82.78%) |
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 382432 385206 386472 391287 393865 397184 397227 405561 411445 414975 417662 417731 417751 417754 420675 422149 423684 424420 425462 426258 426432 427191 428554 428822 429008 429273 431731 432510 434670 442320 444132 444158 444391 445808 446219 447896 448317 449741 451642 454636 454858 457963 459332 461250 461613 462488 464619 465360 466165 466262 467066 467988 469277 470134 470829 471527 471812 472943 473772 480686 482083 483144 484645 485703 485899 486860 486869 487309 490254 494178 497565 497757 500098 500229 502578 507800 508478 510272 510350 510703 512680 512971 514042 514080 515922 517351 517393 525255 527925 529070 531685 534683 537268 538226 545543 550841 551410 556483 556808 557926 559014 565122 567593 568078 569357 570998 573805 579194 584752 594253 598180 601454 603743 604776 617117 621327 626448 652907 661926 768024 ] |
||||||||||||||||||||||||||||||
|
20.76 ms (11.62%) |
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 431731 393865 512971 517351 444158 621327 446219 567593 514042 434670 500229 594253 425462 391287 487309 426258 527925 480686 517393 490254 507800 471527 420675 525255 551410 508478 462488 459332 557926 448317 472943 471812 397184 545543 427191 447896 464619 466262 422149 538226 556483 386472 515922 500098 604776 568078 470829 556808 424420 467066 569357 449741 512680 565122 484645 486869 411445 485899 397227 550841 584752 432510 510272 514080 537268 483144 485703 428554 466165 617117 497565 417662 559014 502578 494178 661926 467988 382432 497757 579194 442320 570998 385206 417751 417754 510703 531685 461613 626448 510350 469277 768024 461250 414975 598180 534683 573805 603743 529070 451642 445808 417731 429273 486860 470134 429008 652907 473772 601454 444391 428822 457963 465360 423684 426432 405561 482083 454858 444132 454636 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.52%) |
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 382432 385206 386472 391287 393865 397184 397227 405561 411445 414975 417662 417731 417751 417754 420675 422149 423684 424420 425462 426258 426432 427191 428554 428822 429008 429273 431731 432510 434670 442320 444132 444158 444391 445808 446219 447896 448317 449741 451642 454636 454858 457963 459332 461250 461613 462488 464619 465360 466165 466262 467066 467988 469277 470134 470829 471527 471812 472943 473772 480686 482083 483144 484645 485703 485899 486860 486869 487309 490254 494178 497565 497757 500098 500229 502578 507800 508478 510272 510350 510703 512680 512971 514042 514080 515922 517351 517393 525255 527925 529070 531685 534683 537268 538226 545543 550841 551410 556483 556808 557926 559014 565122 567593 568078 569357 570998 573805 579194 584752 594253 598180 601454 603743 604776 617117 621327 626448 652907 661926 768024 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bra blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бюстгалтер нижн бел минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.91%) |
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.