Query Metrics
7
Database Queries
7
Different statements
240.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.00 ms (89.04%) |
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 385262 395714 396238 407148 408293 410682 415702 416422 424341 426084 427248 428035 434822 436235 438095 438417 444885 448260 448876 454927 456523 457617 457841 463133 463368 463519 466573 467330 471763 472496 477546 479635 487910 488772 488822 489109 489315 489414 490319 490507 492564 492608 492609 493464 496042 501227 501596 504929 505318 506816 506996 509036 509229 509411 509691 511076 512369 513465 514413 515222 515334 515818 520815 521045 522724 523055 523977 524142 524587 524608 525407 525826 526950 527249 528099 529153 531278 531496 537933 547549 548848 552482 555681 559009 559725 560832 560834 568387 569097 573752 576240 579194 580321 580334 581852 581855 582334 586544 589450 597818 598937 601890 601924 606687 609276 617039 620641 623074 624451 625547 632724 653233 653467 654506 656686 657667 676804 683598 687006 690434 ] |
||||||||||||||||||||||||||||||
|
16.10 ms (6.70%) |
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 489414 496042 501596 509411 523055 490319 492564 509036 511076 529153 479635 555681 471763 438095 493464 514413 489315 623074 601890 559725 580334 601924 552482 573752 656686 624451 524142 385262 427248 428035 444885 424341 472496 463368 506996 505318 512369 523977 531496 537933 466573 568387 560832 580321 657667 687006 683598 653467 690434 547549 597818 625547 632724 408293 436235 438417 395714 396238 415702 448876 457617 526950 513465 525826 488772 489109 515222 515334 525407 527249 488822 501227 504929 515818 576240 589450 609276 410682 416422 454927 531278 522724 528099 492608 548848 560834 579194 581852 676804 653233 559009 569097 581855 582334 598937 586544 463519 467330 448260 456523 457841 426084 407148 434822 477546 509229 509691 521045 524608 524587 490507 492609 506816 520815 487910 654506 606687 620641 617039 463133 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.25%) |
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 385262 395714 396238 407148 408293 410682 415702 416422 424341 426084 427248 428035 434822 436235 438095 438417 444885 448260 448876 454927 456523 457617 457841 463133 463368 463519 466573 467330 471763 472496 477546 479635 487910 488772 488822 489109 489315 489414 490319 490507 492564 492608 492609 493464 496042 501227 501596 504929 505318 506816 506996 509036 509229 509411 509691 511076 512369 513465 514413 515222 515334 515818 520815 521045 522724 523055 523977 524142 524587 524608 525407 525826 526950 527249 528099 529153 531278 531496 537933 547549 548848 552482 555681 559009 559725 560832 560834 568387 569097 573752 576240 579194 580321 580334 581852 581855 582334 586544 589450 597818 598937 601890 601924 606687 609276 617039 620641 623074 624451 625547 632724 653233 653467 654506 656686 657667 676804 683598 687006 690434 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful girlfriend"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая girlfriend"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая girlfriend"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.70%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.