Query Metrics
7
Database Queries
7
Different statements
272.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
247.67 ms (90.81%) |
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 383238 385812 395252 399912 413163 420016 420116 423326 424011 424349 426561 428932 432316 434128 434382 435559 436621 441169 442618 445076 445978 446777 446815 448598 448602 449584 450275 454707 457327 458296 459851 461083 461823 464490 466462 466662 466692 468310 470311 473065 476068 476836 478633 481231 484966 488914 488916 491106 492842 498308 498500 499356 506861 507340 513203 513628 520715 523687 523710 524469 529396 532542 536388 540816 545761 547694 550113 550664 554669 555111 559973 561494 562426 562506 577420 583658 583673 586832 588596 589554 590337 593113 593227 596843 609551 615899 617956 619895 627667 628623 631620 636229 648295 661317 661320 661572 668694 669668 678787 679697 708667 714348 718771 731159 735447 739556 750739 751581 757910 763729 763740 765870 768603 772296 772433 774575 774706 785841 804254 804352 ] |
||||||||||||||||||||||||||||||
|
15.38 ms (5.64%) |
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 561494 628623 804254 804352 450275 464490 466462 420016 385812 424011 441169 473065 554669 583658 679697 714348 708667 636229 461823 481231 436621 459851 491106 498500 484966 488916 413163 445076 435559 445978 529396 550113 545761 577420 661320 661317 668694 617956 590337 619895 596843 609551 772296 772433 763740 768603 731159 751581 763729 785841 395252 513628 488914 513203 524469 399912 432316 426561 423326 424349 458296 478633 498308 532542 507340 550664 547694 648295 588596 627667 615899 428932 446777 434382 420116 461083 476836 492842 559973 555111 520715 470311 506861 434128 540816 448598 448602 454707 466692 446815 449584 468310 476068 562506 583673 661572 718771 678787 593227 631620 589554 774706 757910 735447 750739 765870 739556 774575 442618 466662 523687 499356 523710 383238 593113 457327 536388 562426 669668 586832 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (0.96%) |
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 383238 385812 395252 399912 413163 420016 420116 423326 424011 424349 426561 428932 432316 434128 434382 435559 436621 441169 442618 445076 445978 446777 446815 448598 448602 449584 450275 454707 457327 458296 459851 461083 461823 464490 466462 466662 466692 468310 470311 473065 476068 476836 478633 481231 484966 488914 488916 491106 492842 498308 498500 499356 506861 507340 513203 513628 520715 523687 523710 524469 529396 532542 536388 540816 545761 547694 550113 550664 554669 555111 559973 561494 562426 562506 577420 583658 583673 586832 588596 589554 590337 593113 593227 596843 609551 615899 617956 619895 627667 628623 631620 636229 648295 661317 661320 661572 668694 669668 678787 679697 708667 714348 718771 731159 735447 739556 750739 751581 757910 763729 763740 765870 768603 772296 772433 774575 774706 785841 804254 804352 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"голые девушк соло"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.65%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"голые девушк соло"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"naked girls solo"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.63%) |
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.