Query Metrics
7
Database Queries
7
Different statements
204.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.04 ms (87.50%) |
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 293499 386627 391150 410851 411469 412525 414105 423802 424270 426995 429106 429217 429705 435221 435822 438454 439271 440276 443516 445977 446243 451247 451695 452964 455398 456129 456226 460070 461022 461394 465727 465937 469027 475279 479991 480727 482411 483313 483561 483583 485096 496746 498963 502793 504516 505851 507661 510761 514643 516894 517272 517461 518638 521633 521692 522292 522387 523196 524325 524497 524759 525904 526152 529709 532560 532700 534119 538971 539593 544401 545375 545968 547527 548167 550606 552697 552819 553601 554544 555002 562342 562386 563361 563595 565896 570966 572260 576514 577477 578308 578484 579856 580136 580595 581092 581174 584067 584305 585964 586005 588048 590418 592005 593043 595699 595801 598370 598899 600762 601211 601519 609915 612962 625227 625893 660373 661903 663527 674240 811196 ] |
||||||||||||||||||||||||||||||
|
15.86 ms (7.75%) |
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 479991 424270 429217 456129 452964 496746 526152 544401 563595 600762 598370 601211 517272 426995 429106 440276 465727 483561 445977 480727 502793 521633 523196 485096 554544 552697 580136 586005 411469 423802 435822 584305 414105 529709 504516 524497 562342 460070 581092 553601 293499 439271 451695 461022 505851 483313 386627 391150 435221 410851 451247 534119 539593 521692 525904 524759 552819 576514 579856 562386 555002 661903 674240 572260 585964 612962 625227 625893 811196 429705 438454 455398 475279 469027 514643 578308 598899 456226 443516 517461 524325 510761 584067 663527 609915 595699 590418 483583 498963 522292 516894 518638 532560 532700 547527 577477 570966 578484 580595 581174 545968 595801 593043 461394 465937 507661 538971 482411 545375 550606 563361 565896 660373 548167 588048 601519 446243 412525 592005 522387 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (1.56%) |
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 293499 386627 391150 410851 411469 412525 414105 423802 424270 426995 429106 429217 429705 435221 435822 438454 439271 440276 443516 445977 446243 451247 451695 452964 455398 456129 456226 460070 461022 461394 465727 465937 469027 475279 479991 480727 482411 483313 483561 483583 485096 496746 498963 502793 504516 505851 507661 510761 514643 516894 517272 517461 518638 521633 521692 522292 522387 523196 524325 524497 524759 525904 526152 529709 532560 532700 534119 538971 539593 544401 545375 545968 547527 548167 550606 552697 552819 553601 554544 555002 562342 562386 563361 563595 565896 570966 572260 576514 577477 578308 578484 579856 580136 580595 581092 581174 584067 584305 585964 586005 588048 590418 592005 593043 595699 595801 598370 598899 600762 601211 601519 609915 612962 625227 625893 660373 661903 663527 674240 811196 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam ass finger"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер жоп палец"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.71%) |
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.