Query Metrics
7
Database Queries
7
Different statements
240.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
217.15 ms (90.26%) |
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 391527 391945 391959 392023 404028 417580 418077 418122 419584 423819 424001 434327 435567 435572 435887 436047 438615 439353 439382 442921 445212 448414 448570 448588 449626 450920 451073 452548 452922 452923 454155 456928 458772 459046 459731 460351 460540 463689 463693 465553 469120 470068 473515 475597 477145 477146 479990 481226 493398 493553 495800 500335 504781 508541 509446 510516 512143 513630 517304 518611 518614 519700 520491 520953 521677 523355 523503 523640 525315 526612 528318 532442 534046 534114 536800 546381 546762 547235 548158 551607 554989 555119 556202 556476 558261 561919 562786 567676 568075 569233 571765 572339 573734 577513 590377 595871 597107 597450 597482 600936 602136 669583 678701 683299 719461 722384 739089 741504 742359 751285 757883 761608 770387 776035 787434 792741 801639 805146 825432 827692 ] |
||||||||||||||||||||||||||||||
|
14.05 ms (5.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 434327 520953 495800 523503 448414 493553 442921 477146 418122 391959 741504 404028 595871 504781 463689 518614 534046 448588 456928 449626 475597 509446 512143 597450 493398 805146 436047 435567 391527 518611 536800 562786 551607 597107 481226 477145 827692 825432 571765 567676 438615 419584 450920 435887 445212 452922 454155 452548 418077 452923 500335 561919 479990 448570 520491 523355 439382 546381 569233 556202 460351 463693 526612 521677 590377 678701 459731 435572 508541 683299 669583 751285 787434 459046 469120 391945 460540 528318 525315 572339 577513 417580 458772 470068 510516 532442 547235 556476 568075 722384 548158 602136 770387 439353 451073 473515 423819 534114 519700 719461 554989 597482 600936 801639 757883 761608 739089 742359 776035 792741 513630 523640 517304 558261 573734 546762 555119 392023 424001 465553 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.15%) |
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 391527 391945 391959 392023 404028 417580 418077 418122 419584 423819 424001 434327 435567 435572 435887 436047 438615 439353 439382 442921 445212 448414 448570 448588 449626 450920 451073 452548 452922 452923 454155 456928 458772 459046 459731 460351 460540 463689 463693 465553 469120 470068 473515 475597 477145 477146 479990 481226 493398 493553 495800 500335 504781 508541 509446 510516 512143 513630 517304 518611 518614 519700 520491 520953 521677 523355 523503 523640 525315 526612 528318 532442 534046 534114 536800 546381 546762 547235 548158 551607 554989 555119 556202 556476 558261 561919 562786 567676 568075 569233 571765 572339 573734 577513 590377 595871 597107 597450 597482 600936 602136 669583 678701 683299 719461 722384 739089 741504 742359 751285 757883 761608 770387 776035 787434 792741 801639 805146 825432 827692 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"девушки украины дилдÐâ…"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк русск дилд"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.60%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.57%) |
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.