Query Metrics
7
Database Queries
7
Different statements
233.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
203.71 ms (87.43%) |
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 382642 415957 416512 418138 418149 419445 420277 428753 429844 432976 434325 434330 434350 439130 444180 450670 451863 452910 457092 459761 460813 466455 466700 468661 473055 476055 476317 478030 486765 492942 493849 497831 500340 502018 504144 504781 511372 514034 514907 529382 536379 538977 541469 543726 545037 546987 547485 552699 554949 556442 556461 560684 560872 560898 564641 564642 564864 566675 567770 569354 569594 569619 573343 576201 578258 579344 581428 584460 587317 587442 588770 589522 590255 590281 593325 595637 600428 600986 602147 602229 602343 606109 606139 616194 620981 630930 632727 641517 641774 643671 651589 661694 671054 677022 678195 681703 683275 685807 697101 716551 722405 739815 740817 743745 750448 750449 752709 753554 754816 757586 757789 758088 774211 780758 781260 786932 805450 807235 808475 ] |
||||||||||||||||||||||||||||||
|
17.88 ms (7.67%) |
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 590255 473055 514034 529382 556442 556461 569354 573343 541469 543726 671054 678195 681703 697101 722405 661694 683275 677022 685807 568067 587317 641517 643671 589522 630930 606139 641774 807235 808475 780758 781260 805450 750448 753554 786932 740817 743745 750449 754816 757586 774211 752709 757789 739815 758088 602229 616194 632727 716551 382642 451863 514907 415957 416512 468661 486765 500340 504144 547485 578258 584460 546987 590281 511372 418149 419445 432976 434330 434350 450670 466700 502018 538977 536379 560898 566675 560684 564641 567770 569594 576201 545037 560872 569619 651589 554949 581428 588770 600986 602147 606109 593325 600428 620981 595637 587442 602343 434325 418138 439130 459761 466455 428753 452910 460813 476317 444180 457092 493849 497831 420277 429844 478030 492942 504781 476055 564642 579344 552699 564864 ] |
||||||||||||||||||||||||||||||
|
3.98 ms (1.71%) |
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 382642 415957 416512 418138 418149 419445 420277 428753 429844 432976 434325 434330 434350 439130 444180 450670 451863 452910 457092 459761 460813 466455 466700 468661 473055 476055 476317 478030 486765 492942 493849 497831 500340 502018 504144 504781 511372 514034 514907 529382 536379 538977 541469 543726 545037 546987 547485 552699 554949 556442 556461 560684 560872 560898 564641 564642 564864 566675 567770 569354 569594 569619 573343 576201 578258 579344 581428 584460 587317 587442 588770 589522 590255 590281 593325 595637 600428 600986 602147 602229 602343 606109 606139 616194 620981 630930 632727 641517 641774 643671 651589 661694 671054 677022 678195 681703 683275 685807 697101 716551 722405 739815 740817 743745 750448 750449 752709 753554 754816 757586 757789 758088 774211 780758 781260 786932 805450 807235 808475 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny solo dildo"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые соло дилд"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.71%) |
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.