Query Metrics
7
Database Queries
7
Different statements
268.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
237.64 ms (88.61%) |
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 411838 417177 419178 420139 420587 420695 421118 422028 424328 424360 425131 425300 425316 426084 426653 429650 430601 430625 430661 431965 436933 438095 441626 442195 442335 442835 452491 454856 454924 457629 459784 461595 461599 465010 465103 468433 472208 472524 473102 473923 476022 477545 477546 478818 481149 481822 482409 482674 487719 489434 502480 506841 508492 508497 508516 512384 514645 518403 518558 519272 520826 520828 521534 522107 522556 523474 523600 525287 527667 528030 534850 534968 542971 543048 544663 544863 545586 551130 551736 553949 556453 558348 559754 562953 563549 573800 575534 579493 584990 586024 590856 591151 593849 593855 593875 595907 598038 600193 603629 603683 605445 606267 609413 615443 617195 618017 630915 631908 635490 636579 654671 732791 746252 750704 765643 770708 775809 785388 789862 827850 ] |
||||||||||||||||||||||||||||||
|
20.40 ms (7.61%) |
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 559754 595907 461595 426653 502480 425316 452491 425300 417177 508497 441626 518403 419178 436933 534850 489434 421118 506841 426084 827850 431965 461599 544663 598038 785388 478818 454924 454856 420587 459784 457629 521534 465103 603629 465010 477546 411838 420139 477545 424360 562953 523600 615443 631908 545586 522107 593875 534968 438095 563549 482409 519272 523474 487719 654671 746252 556453 430661 476022 593855 750704 425131 765643 520828 473102 579493 575534 468433 520826 558348 586024 590856 618017 775809 522556 482674 606267 508516 543048 591151 635490 553949 442195 481822 430625 420695 584990 518558 732791 605445 617195 542971 630915 609413 472524 442335 551130 593849 422028 527667 424328 600193 514645 473923 508492 472208 770708 442835 429650 603683 528030 430601 636579 481149 789862 573800 512384 551736 544863 525287 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (0.89%) |
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 411838 417177 419178 420139 420587 420695 421118 422028 424328 424360 425131 425300 425316 426084 426653 429650 430601 430625 430661 431965 436933 438095 441626 442195 442335 442835 452491 454856 454924 457629 459784 461595 461599 465010 465103 468433 472208 472524 473102 473923 476022 477545 477546 478818 481149 481822 482409 482674 487719 489434 502480 506841 508492 508497 508516 512384 514645 518403 518558 519272 520826 520828 521534 522107 522556 523474 523600 525287 527667 528030 534850 534968 542971 543048 544663 544863 545586 551130 551736 553949 556453 558348 559754 562953 563549 573800 575534 579493 584990 586024 590856 591151 593849 593855 593875 595907 598038 600193 603629 603683 605445 606267 609413 615443 617195 618017 630915 631908 635490 636579 654671 732791 746252 750704 765643 770708 775809 785388 789862 827850 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur pov threesome"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.69%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск пов секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.60%) |
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.