Query Metrics
7
Database Queries
7
Different statements
150.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.83 ms (82.40%) |
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 287459 385928 391059 400679 404738 410602 413376 414197 416724 420038 422012 422233 426348 426360 427804 428499 428998 429319 440698 441192 442013 446612 446902 447809 448884 449434 449516 451316 452666 454343 454499 454627 456555 457141 457974 458136 459447 460697 468375 469731 470133 471372 472739 472764 476027 478654 479764 480210 484286 485994 487979 502800 504322 507408 507677 511973 512973 513007 514956 518233 520785 542218 545199 548966 549864 556445 559986 561882 574027 574577 575154 577087 577140 584915 585160 587260 587477 592197 592321 598504 604338 605727 609388 623005 630697 646429 652179 657136 657219 659034 661570 668079 668279 668294 673173 687339 695831 704156 712230 717842 719600 720111 720306 720778 721579 731303 740489 748053 756078 761556 761582 770253 787500 794096 803112 807435 812704 819588 ] |
||||||||||||||||||||||||||||||
|
16.13 ms (10.73%) |
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 575154 545199 548966 668294 673173 687339 719600 668279 695831 721579 657219 668079 556445 587260 585160 592197 807435 803112 748053 761556 770253 731303 609388 630697 787500 794096 427804 447809 452666 476027 416724 422012 414197 470133 454343 472739 478654 479764 520785 502800 507677 428499 440698 484286 454499 518233 513007 513372 574027 577087 584915 646429 623005 812704 712230 448884 413376 454627 456520 400679 404738 441192 429319 480210 449516 459447 487979 468375 561882 720778 652179 720306 605727 598504 592321 756078 740489 761582 717842 287459 428998 442013 456555 385928 426360 458136 471372 391059 426348 420038 457141 504322 485994 542218 472764 512973 819588 451316 449434 514956 507408 574577 549864 559986 577140 661570 704156 657136 659034 604338 587477 720111 410602 422233 446902 457974 469731 446612 460697 511973 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (2.09%) |
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 287459 385928 391059 400679 404738 410602 413376 414197 416724 420038 422012 422233 426348 426360 427804 428499 428998 429319 440698 441192 442013 446612 446902 447809 448884 449434 449516 451316 452666 454343 454499 454627 456555 457141 457974 458136 459447 460697 468375 469731 470133 471372 472739 472764 476027 478654 479764 480210 484286 485994 487979 502800 504322 507408 507677 511973 512973 513007 514956 518233 520785 542218 545199 548966 549864 556445 559986 561882 574027 574577 575154 577087 577140 584915 585160 587260 587477 592197 592321 598504 604338 605727 609388 623005 630697 646429 652179 657136 657219 659034 661570 668079 668279 668294 673173 687339 695831 704156 712230 717842 719600 720111 720306 720778 721579 731303 740489 748053 756078 761556 761582 770253 787500 794096 803112 807435 812704 819588 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen tight жоп"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen tight ass"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen tight жоп"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.