Query Metrics
7
Database Queries
7
Different statements
153.62 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.89 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.38 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot onlyfans"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.13 ms |
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 602338 603783 614209 775960 801636 805945 811998 775967 811755 760619 787075 764761 770397 773257 608715 779012 806668 812589 580818 582633 580807 582712 555657 561607 662594 687094 650028 565782 586639 588591 600449 602572 594099 619180 590102 594262 596748 601806 783311 813191 724425 775848 787586 791048 793608 546594 560660 552444 559989 598622 603858 590881 595682 603831 598921 632169 613508 791738 767601 625729 522089 572328 557042 670564 590288 615918 595799 577931 709260 563630 556741 625215 621271 625205 591351 608203 627773 532531 633611 659369 627700 591176 621265 611392 420515 ] |
||||||||||||||||||||||||||||||
| 4 | 3.98 ms |
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 420515 522089 532531 546594 552444 555657 556741 557042 559989 560660 561607 563630 565782 572328 577931 580807 580818 582633 582712 586639 588591 590102 590288 590881 591176 591351 594099 594262 595682 595799 596748 598622 598921 600449 601806 602338 602572 603783 603831 603858 608203 608715 611392 613508 614209 615918 619180 621265 621271 625205 625215 625729 627700 627773 632169 633611 650028 659369 662594 670564 687094 709260 724425 760619 764761 767601 770397 773257 775848 775960 775967 779012 783311 787075 787586 791048 791738 793608 801636 805945 806668 811755 811998 812589 813191 ] |
||||||||||||||||||||||||||||||
| 5 | 126.02 ms |
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 420515 522089 532531 546594 552444 555657 556741 557042 559989 560660 561607 563630 565782 572328 577931 580807 580818 582633 582712 586639 588591 590102 590288 590881 591176 591351 594099 594262 595682 595799 596748 598622 598921 600449 601806 602338 602572 603783 603831 603858 608203 608715 611392 613508 614209 615918 619180 621265 621271 625205 625215 625729 627700 627773 632169 633611 650028 659369 662594 670564 687094 709260 724425 760619 764761 767601 770397 773257 775848 775960 775967 779012 783311 787075 787586 791048 791738 793608 801636 805945 806668 811755 811998 812589 813191 ] |
||||||||||||||||||||||||||||||
| 6 | 2.23 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot онлифанс социальн сет"
]
|
||||||||||||||||||||||||||||||
| 7 | 2.00 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot онлифанс социальн сет"
]
|
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.