Query Metrics
7
Database Queries
7
Different statements
410.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.53 ms (52.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чулк нижн бел большие cock"
]
|
||||||||||||||||||||||||||||||
|
170.50 ms (41.58%) |
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 5344 11947 11969 32549 181612 187048 355294 385954 388887 389745 404576 407291 409045 411415 413947 416236 416255 418542 423199 423844 423944 425947 436694 437133 437174 438638 456522 457016 459324 460319 460844 463403 463728 464104 464552 465300 465351 468190 468534 471619 475377 476074 478163 481793 482519 483106 488023 488331 501082 503494 505221 511151 511957 512733 512894 517548 520967 522586 522591 533986 537945 538686 541749 544289 544293 547657 554053 555640 555652 556652 560362 562676 563409 567213 575552 587229 603656 606287 608787 609627 619151 619894 621183 625165 627111 640210 660301 665446 667209 675060 675438 675702 679367 680322 689291 689351 692131 709911 716211 722833 724990 727239 729225 732955 737992 740875 745017 751499 754453 757480 759554 776860 800920 803712 811232 818003 818364 818616 828162 828755 ] |
||||||||||||||||||||||||||||||
|
17.04 ms (4.16%) |
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 828755 533986 512733 759554 459324 460319 501082 505221 476074 418542 575552 729225 475377 478163 413947 522586 423944 404576 456522 483106 520967 608787 468190 828162 544293 716211 554053 5344 555652 556652 679367 689291 692131 722833 680322 709911 555640 640210 621183 803712 724990 757480 727239 740875 627111 800920 606287 567213 751499 437133 818364 560362 675060 11947 737992 464104 488331 389745 511957 522591 438638 423844 463403 776860 732955 187048 667209 609627 754453 409045 541749 619894 11969 811232 745017 457016 537945 482519 471619 411415 437174 460844 538686 423199 436694 465300 416236 665446 562676 511151 32549 689351 660301 675438 675702 547657 625165 355294 481793 587229 512894 388887 563409 544289 619151 181612 407291 465351 517548 603656 416255 463728 503494 468534 385954 425947 464552 488023 818003 818616 ] |
||||||||||||||||||||||||||||||
|
3.69 ms (0.90%) |
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 5344 11947 11969 32549 181612 187048 355294 385954 388887 389745 404576 407291 409045 411415 413947 416236 416255 418542 423199 423844 423944 425947 436694 437133 437174 438638 456522 457016 459324 460319 460844 463403 463728 464104 464552 465300 465351 468190 468534 471619 475377 476074 478163 481793 482519 483106 488023 488331 501082 503494 505221 511151 511957 512733 512894 517548 520967 522586 522591 533986 537945 538686 541749 544289 544293 547657 554053 555640 555652 556652 560362 562676 563409 567213 575552 587229 603656 606287 608787 609627 619151 619894 621183 625165 627111 640210 660301 665446 667209 675060 675438 675702 679367 680322 689291 689351 692131 709911 716211 722833 724990 727239 729225 732955 737992 740875 745017 751499 754453 757480 759554 776860 800920 803712 811232 818003 818364 818616 828162 828755 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stockings big cock"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"чулк нижн бел большие cock"
]
|
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.