Query Metrics
7
Database Queries
7
Different statements
209.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.13 ms (82.72%) |
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 346122 391911 391986 391992 392007 398114 400942 415755 419454 429861 429900 430353 433001 434334 435550 445103 455080 456230 462928 465327 465562 466035 468220 469199 471012 472806 472907 476046 476671 493254 494247 506353 513628 513641 513642 513654 513681 516640 517809 517810 519354 519358 519359 519368 520910 526570 528608 535387 536462 545964 547462 547478 547807 555016 555020 555024 556337 556899 558316 559430 559973 561015 561519 562420 562784 563081 570948 573204 574438 575028 578177 580577 583464 585365 590145 590487 591320 592923 595072 596324 605133 605219 611795 615921 622385 629799 633204 669018 669387 671049 711651 714309 714324 714461 721895 722379 742298 752687 754903 757226 770963 772584 776544 789561 797326 799155 799695 800339 800473 802282 802899 809540 810086 810091 810092 811771 812385 812756 825514 826018 ] |
||||||||||||||||||||||||||||||
|
24.32 ms (11.62%) |
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 434334 472806 391992 435550 445103 519354 526570 398114 455080 465562 456230 471012 476671 528608 536462 545964 547478 555020 562420 573204 547807 547462 555024 669387 714309 669018 721895 561015 605133 605219 590487 622385 633204 615921 629799 590145 802899 519358 519368 520910 493254 513641 513654 517810 519359 516640 562784 559973 346122 400942 826018 825514 462928 465327 476046 466035 506353 494247 472907 561519 574438 556899 570948 575028 578177 580577 556337 563081 671049 714461 714324 583464 585365 595072 591320 592923 596324 611795 789561 799695 800339 809540 811771 797326 802282 812385 752687 772584 800473 810086 810091 812756 754903 757226 770963 742298 711651 722379 799155 810092 415755 513628 517809 513642 513681 535387 429900 555016 776544 391911 433001 468220 558316 559430 392007 469199 391986 429861 430353 419454 ] |
||||||||||||||||||||||||||||||
|
4.47 ms (2.13%) |
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 346122 391911 391986 391992 392007 398114 400942 415755 419454 429861 429900 430353 433001 434334 435550 445103 455080 456230 462928 465327 465562 466035 468220 469199 471012 472806 472907 476046 476671 493254 494247 506353 513628 513641 513642 513654 513681 516640 517809 517810 519354 519358 519359 519368 520910 526570 528608 535387 536462 545964 547462 547478 547807 555016 555020 555024 556337 556899 558316 559430 559973 561015 561519 562420 562784 563081 570948 573204 574438 575028 578177 580577 583464 585365 590145 590487 591320 592923 595072 596324 605133 605219 611795 615921 622385 629799 633204 669018 669387 671049 711651 714309 714324 714461 721895 722379 742298 752687 754903 757226 770963 772584 776544 789561 797326 799155 799695 800339 800473 802282 802899 809540 810086 810091 810092 811771 812385 812756 825514 826018 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature brunette solo"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature черноволосая соло"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature черноволосая соло"
]
|
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.