Query Metrics
8
Database Queries
8
Different statements
198.56 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.62 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.06 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"onlyfans teen anal"
]
|
||||||||||||||||||||||||||||||
| 3 | 1.62 ms |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01”\x07®\x12Hrê¥y0xPwP/"
]
|
||||||||||||||||||||||||||||||
| 4 | 15.80 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 610390 555858 574727 545392 545436 576128 695178 655555 547493 613860 640270 593724 806591 766590 744704 791048 515968 688369 466739 569567 574036 575832 658981 593639 601475 587397 596748 813191 542709 593656 615881 628069 628073 644526 775900 517843 821851 558159 722380 599197 595209 807580 725647 784493 808327 785572 696233 551579 580472 545404 545429 574731 660060 683446 584531 619361 588534 579139 588071 593958 628072 642875 541275 814175 560660 561944 593886 790754 797560 767601 545376 667985 596933 593729 615918 500772 580574 615878 595471 637537 545428 559453 545390 722373 627817 806580 585826 571334 604016 584515 656322 621271 624165 551816 590763 584503 557676 596856 608407 547490 600696 624171 594569 556741 628068 686179 633611 623413 783069 492527 787544 619746 626497 551487 602739 ] |
||||||||||||||||||||||||||||||
| 5 | 2.82 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 466739 492527 500772 515968 517843 541275 542709 545376 545390 545392 545404 545428 545429 545436 547490 547493 551487 551579 551816 555858 556741 557676 558159 559453 560660 561944 569567 571334 574036 574727 574731 575832 576128 579139 580472 580574 584503 584515 584531 585826 587397 588071 588534 590763 593639 593656 593724 593729 593886 593958 594569 595209 595471 596748 596856 596933 599197 600696 601475 602739 604016 608407 610390 613860 615878 615881 615918 619361 619746 621271 623413 624165 624171 626497 627817 628068 628069 628072 628073 633611 637537 640270 642875 644526 655555 656322 658981 660060 667985 683446 686179 688369 695178 696233 722373 722380 725647 744704 766590 767601 775900 783069 784493 785572 787544 790754 791048 797560 806580 806591 808327 813191 814175 821851 ] |
||||||||||||||||||||||||||||||
| 6 | 171.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 466739 492527 500772 515968 517843 541275 542709 545376 545390 545392 545404 545428 545429 545436 547490 547493 551487 551579 551816 555858 556741 557676 558159 559453 560660 561944 569567 571334 574036 574727 574731 575832 576128 579139 580472 580574 584503 584515 584531 585826 587397 588071 588534 590763 593639 593656 593724 593729 593886 593958 594569 595209 595471 596748 596856 596933 599197 600696 601475 602739 604016 608407 610390 613860 615878 615881 615918 619361 619746 621271 623413 624165 624171 626497 627817 628068 628069 628072 628073 633611 637537 640270 642875 644526 655555 656322 658981 660060 667985 683446 686179 688369 695178 696233 722373 722380 725647 744704 766590 767601 775900 783069 784493 785572 787544 790754 791048 797560 806580 806591 808327 813191 814175 821851 ] |
||||||||||||||||||||||||||||||
| 7 | 1.90 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"онлифанс социальн сет teen анал"
]
|
||||||||||||||||||||||||||||||
| 8 | 1.71 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"онлифанс социальн сет teen анал"
]
|
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.