Query Metrics
7
Database Queries
7
Different statements
202.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.24 ms (86.49%) |
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 6640 40000 67112 107216 152529 191336 343369 381942 385116 385752 388570 391018 391950 393027 393558 396338 397174 398122 398791 400706 401678 403243 404451 407377 407636 407793 411942 412957 413612 414027 431504 433814 447094 455438 456999 469379 470937 473891 479969 484395 487351 491864 495266 495516 495581 496307 496973 502025 502613 503069 503565 513822 513889 517989 518909 524240 525545 526642 527016 530445 539348 539371 542723 543943 544795 546892 549714 554448 554532 557052 562423 564749 564889 569370 570764 570966 573297 574427 574678 577126 577192 584339 592973 593003 593531 599670 622315 645300 650608 695171 726512 726537 726710 726712 726713 727554 785330 808045 808054 810136 810893 813749 814104 814722 817048 819196 819346 819371 823169 824441 824531 824634 825340 825358 825437 826698 827097 827287 827926 827977 ] |
||||||||||||||||||||||||||||||
|
16.69 ms (8.24%) |
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 808045 808054 810136 152529 393558 385116 398122 400706 107216 391950 388570 470937 484395 404451 412957 431504 487351 447094 473891 502025 503565 513889 496973 517989 554448 574427 570764 570966 574678 695171 557052 562423 592973 622315 593003 599670 593531 785330 810893 726512 726537 726713 726712 726710 727554 411942 469379 455438 456999 526642 527016 518909 385752 67112 191336 393027 343369 381942 40000 6640 391018 396338 397174 398791 401678 403243 407377 407636 407793 414027 413612 433814 813749 814722 819371 823169 825437 826698 814104 817048 824441 827097 827287 819346 824531 824634 825358 819196 825340 827977 827926 479969 491864 502613 503069 495516 495581 513822 524240 525545 496307 530445 539371 495266 539348 543943 569370 577126 542723 544795 546892 573297 549714 554532 564749 564889 577192 584339 645300 650608 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.55%) |
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 6640 40000 67112 107216 152529 191336 343369 381942 385116 385752 388570 391018 391950 393027 393558 396338 397174 398122 398791 400706 401678 403243 404451 407377 407636 407793 411942 412957 413612 414027 431504 433814 447094 455438 456999 469379 470937 473891 479969 484395 487351 491864 495266 495516 495581 496307 496973 502025 502613 503069 503565 513822 513889 517989 518909 524240 525545 526642 527016 530445 539348 539371 542723 543943 544795 546892 549714 554448 554532 557052 562423 564749 564889 569370 570764 570966 573297 574427 574678 577126 577192 584339 592973 593003 593531 599670 622315 645300 650608 695171 726512 726537 726710 726712 726713 727554 785330 808045 808054 810136 810893 813749 814104 814722 817048 819196 819346 819371 823169 824441 824531 824634 825340 825358 825437 826698 827097 827287 827926 827977 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy chubby"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy chubby"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy chubby"
]
|
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.