Query Metrics
7
Database Queries
7
Different statements
155.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.02 ms (85.73%) |
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 2571 4173 14508 33756 34645 66162 74239 81174 131772 142823 151113 168596 185011 260041 264454 270515 308297 310706 313892 382418 382942 384535 386636 387486 388935 389135 392959 396095 397843 397941 398032 414618 414932 417548 419018 423120 423890 426094 430286 433553 435351 439372 441923 445331 445343 445484 445669 447386 447658 449271 452435 457253 460439 462039 462883 463772 466193 466806 470402 473388 473582 474878 475861 476377 479042 481036 481353 482326 482949 487615 491900 501040 502450 503400 504831 506727 509498 509669 512118 514274 520320 522087 523169 525661 525893 527898 547874 547987 552995 558076 558213 559898 563004 566244 569942 570500 570613 573715 577603 595518 595708 597535 600833 616765 622252 666772 707692 707706 743027 748606 756295 765621 768554 780281 806787 814376 817893 818270 825898 827189 ] |
||||||||||||||||||||||||||||||
|
13.26 ms (8.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 423120 577603 768554 501040 504831 476377 817893 756295 81174 66162 616765 452435 473582 449271 474878 502450 387486 818270 827189 569942 748606 743027 396095 559898 386636 503400 595708 260041 308297 814376 595518 509669 780281 481353 473388 487615 707706 506727 570500 313892 185011 34645 382418 573715 666772 4173 419018 512118 392959 310706 414932 270515 397941 384535 462883 558076 264454 426094 445331 397843 482949 168596 14508 2571 447658 398032 475861 527898 765621 433553 525661 388935 597535 481036 414618 600833 622252 463772 33756 707692 142823 520320 523169 806787 447386 479042 522087 74239 423890 445343 445484 457253 563004 547874 389135 558213 460439 151113 445669 566244 462039 491900 470402 525893 131772 417548 509498 547987 552995 430286 825898 482326 382942 435351 514274 466806 570613 466193 441923 439372 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.46%) |
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 2571 4173 14508 33756 34645 66162 74239 81174 131772 142823 151113 168596 185011 260041 264454 270515 308297 310706 313892 382418 382942 384535 386636 387486 388935 389135 392959 396095 397843 397941 398032 414618 414932 417548 419018 423120 423890 426094 430286 433553 435351 439372 441923 445331 445343 445484 445669 447386 447658 449271 452435 457253 460439 462039 462883 463772 466193 466806 470402 473388 473582 474878 475861 476377 479042 481036 481353 482326 482949 487615 491900 501040 502450 503400 504831 506727 509498 509669 512118 514274 520320 522087 523169 525661 525893 527898 547874 547987 552995 558076 558213 559898 563004 566244 569942 570500 570613 573715 577603 595518 595708 597535 600833 616765 622252 666772 707692 707706 743027 748606 756295 765621 768554 780281 806787 814376 817893 818270 825898 827189 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"поз position 69 секс"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"69 position sex"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"поз position 69 секс"
]
|
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.