Query Metrics
7
Database Queries
7
Different statements
216.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
192.47 ms (88.99%) |
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 73421 383656 390220 390723 401968 412578 412911 413546 415524 416988 418659 420576 420596 425586 425814 428847 429713 438373 440724 444043 445447 446550 447083 449603 455167 458103 458296 458403 458661 459505 462193 462289 463674 468145 468206 469100 469537 470548 472266 473091 478122 478123 479226 479574 480348 480765 483692 483715 484939 485336 487868 488995 489347 495670 497179 497799 500441 500710 501647 503887 504348 507451 508530 511296 511548 511622 512231 512652 512951 514046 515661 516156 517079 518110 518200 518385 518446 519213 521864 523520 524200 524479 524592 524644 524653 524782 525911 526632 528151 528652 528711 528887 533305 534665 538232 538603 538695 561694 561820 562243 566577 569861 570030 571963 580281 585054 586136 588697 597472 598940 608715 633468 650016 684666 813584 813932 814384 817460 818582 818795 ] |
||||||||||||||||||||||||||||||
|
14.58 ms (6.74%) |
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 401968 415524 458403 462193 418659 425586 425814 428847 416988 412578 447083 459505 518385 538232 524644 524653 483692 484939 504348 525911 562243 469537 446550 485336 515661 518200 534665 570030 561694 561820 569861 580281 684666 571963 586136 598940 588697 597472 608715 390723 413546 429713 462289 468206 469100 470548 478122 480765 445447 458103 468145 473091 478123 480348 412911 420576 420596 438373 455167 463674 472266 444043 449603 503887 511622 523520 524200 524479 528151 487868 500710 511548 512652 512951 516156 518110 519213 521864 526632 528887 483715 497179 497799 501647 508530 511296 512231 514046 524592 524782 495670 500441 517079 518446 528652 528711 566577 650016 633468 488995 383656 73421 390220 440724 585054 813584 814384 818795 818582 813932 817460 458296 458661 479574 479226 489347 507451 533305 538603 538695 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.34%) |
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 73421 383656 390220 390723 401968 412578 412911 413546 415524 416988 418659 420576 420596 425586 425814 428847 429713 438373 440724 444043 445447 446550 447083 449603 455167 458103 458296 458403 458661 459505 462193 462289 463674 468145 468206 469100 469537 470548 472266 473091 478122 478123 479226 479574 480348 480765 483692 483715 484939 485336 487868 488995 489347 495670 497179 497799 500441 500710 501647 503887 504348 507451 508530 511296 511548 511622 512231 512652 512951 514046 515661 516156 517079 518110 518200 518385 518446 519213 521864 523520 524200 524479 524592 524644 524653 524782 525911 526632 528151 528652 528711 528887 533305 534665 538232 538603 538695 561694 561820 562243 566577 569861 570030 571963 580281 585054 586136 588697 597472 598940 608715 633468 650016 684666 813584 813932 814384 817460 818582 818795 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful sexy"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.74%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая sexy"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.69%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.33 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая sexy"
]
|
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.