Query Metrics
7
Database Queries
7
Different statements
207.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
184.38 ms (88.97%) |
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 390212 391921 391943 416683 417408 418411 420886 421488 424556 429330 435547 437059 441610 443555 445187 445426 447549 448846 449847 450630 452302 454647 459111 460301 461437 461454 462854 463863 463897 463906 463917 463938 464247 464550 469756 470278 470330 470458 470856 471688 472111 473193 473387 475806 476737 478901 479483 480008 482076 485546 488421 496448 496818 497613 503477 504450 505452 505626 510631 510855 511721 512014 513701 517204 517431 517663 518619 519309 520542 520853 521089 522024 522219 524754 526050 526555 528223 528862 529557 530001 531780 534528 537051 541274 548158 555091 556331 563438 570130 576916 580236 580239 589029 590498 595483 598141 616013 620220 623681 652852 672890 677677 678571 679102 711074 712633 722623 730011 742281 745556 761842 765268 770410 771591 778607 791127 807011 809782 814984 825751 ] |
||||||||||||||||||||||||||||||
|
14.16 ms (6.83%) |
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 459111 462854 463906 463938 417408 443555 445187 460301 461437 476737 479483 482076 416683 424556 448846 463897 464550 470856 471688 421488 449847 464247 472111 512014 505626 511721 518619 522024 526050 485546 496448 517663 623681 595483 473387 390212 480008 513701 524754 814984 534528 478901 522219 521089 589029 450630 470278 470458 391943 429330 435547 469756 517204 528862 503477 520853 496818 497613 510631 504450 771591 391921 526555 563438 570130 580236 711074 576916 616013 473193 454647 463863 470330 418411 447549 452302 461454 463917 420886 530001 488421 517431 505452 510855 519309 529557 520542 445426 672890 791127 441610 825751 537051 528223 531780 541274 556331 555091 580239 712633 652852 679102 677677 678571 722623 548158 590498 598141 620220 778607 809782 765268 807011 742281 730011 745556 761842 770410 437059 475806 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.20%) |
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 390212 391921 391943 416683 417408 418411 420886 421488 424556 429330 435547 437059 441610 443555 445187 445426 447549 448846 449847 450630 452302 454647 459111 460301 461437 461454 462854 463863 463897 463906 463917 463938 464247 464550 469756 470278 470330 470458 470856 471688 472111 473193 473387 475806 476737 478901 479483 480008 482076 485546 488421 496448 496818 497613 503477 504450 505452 505626 510631 510855 511721 512014 513701 517204 517431 517663 518619 519309 520542 520853 521089 522024 522219 524754 526050 526555 528223 528862 529557 530001 531780 534528 537051 541274 548158 555091 556331 563438 570130 576916 580236 580239 589029 590498 595483 598141 616013 620220 623681 652852 672890 677677 678571 679102 711074 712633 722623 730011 742281 745556 761842 765268 770410 771591 778607 791127 807011 809782 814984 825751 ] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал toys русск"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал toys русск"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal toys russian"
]
|
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.