Query Metrics
7
Database Queries
7
Different statements
136.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
113.73 ms (83.51%) |
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 99632 162721 389495 389532 389840 405541 407856 413286 418441 423106 425977 428872 428907 430777 439608 448701 450161 451501 451891 452778 453520 455958 457424 460335 460534 464125 464925 468033 478616 487892 494178 506339 508602 518614 523618 528230 530364 530464 537777 538961 542206 554513 555175 558921 560392 569187 573214 584284 588141 600277 604867 606595 616521 616849 619702 625907 626825 629743 636965 645962 647331 661049 665048 668480 708303 717665 720810 724280 728554 739298 740055 744344 746461 750743 754990 755394 759685 760179 767428 770021 772769 774105 776820 777097 779173 788711 795724 797186 805832 813307 814541 817389 817447 817654 818454 818514 819152 819402 819925 823801 824267 824359 824984 825472 826434 826636 827115 827240 828006 828035 828109 828142 828218 828370 828383 828457 828703 ] |
||||||||||||||||||||||||||||||
|
12.47 ms (9.15%) |
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 478616 452778 460534 584284 558921 606595 616849 453520 389495 389532 428907 450161 428872 464925 528230 407856 413286 425977 405541 828370 769936 750743 760179 823925 604867 636965 788711 720810 776820 826636 828703 554513 518614 418441 457424 455958 451891 487892 538961 537777 464125 468033 560392 668480 717665 708303 616521 805832 430777 460335 389840 423106 439608 451501 494178 506339 523618 824267 817447 823801 814541 819402 828035 828142 530464 772769 818454 818514 827115 825472 826434 448701 542206 647331 629743 625907 626825 774105 728554 740055 770021 817654 819925 817389 827240 824984 826432 824359 828109 828218 828457 530364 573214 619702 600277 661049 99632 162721 819152 828006 828383 508602 569187 665048 645962 555175 588141 777097 779173 795724 754990 767428 797186 739298 755394 759685 746461 724280 744344 813307 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.77%) |
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 99632 162721 389495 389532 389840 405541 407856 413286 418441 423106 425977 428872 428907 430777 439608 448701 450161 451501 451891 452778 453520 455958 457424 460335 460534 464125 464925 468033 478616 487892 494178 506339 508602 518614 523618 528230 530364 530464 537777 538961 542206 554513 555175 558921 560392 569187 573214 584284 588141 600277 604867 606595 616521 616849 619702 625907 626825 629743 636965 645962 647331 661049 665048 668480 708303 717665 720810 724280 728554 739298 740055 744344 746461 750743 754990 755394 759685 760179 767428 770021 772769 774105 776820 777097 779173 788711 795724 797186 805832 813307 814541 817389 817447 817654 818454 818514 819152 819402 819925 823801 824267 824359 824984 825472 826434 826636 827115 827240 828006 828035 828109 828142 828218 828370 828383 828457 828703 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf glasses"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf очкастая"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf очкастая"
]
|
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.