Query Metrics
7
Database Queries
7
Different statements
154.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.04 ms (82.94%) |
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 4510 7677 101065 120432 188610 229210 263144 285162 358438 389312 395709 396881 399367 400487 403003 411213 422751 431682 439499 442194 447979 448924 449335 453688 457288 457306 459628 460854 461428 463153 463659 465369 467413 468589 469412 470946 472447 472832 476326 477781 478223 480357 484095 489353 494371 502644 504567 507178 512538 520493 526618 527439 532911 532945 532971 540759 544465 547061 575525 579322 581962 582777 590360 590506 612065 613465 617730 620158 624785 631930 631980 641689 644956 647361 672489 672506 673170 687815 701819 702401 711782 715707 720254 728244 728348 730272 730852 732443 738371 742128 748325 748467 757973 764919 768351 769924 776454 784393 784932 784954 786431 787309 787860 788424 798986 800344 800554 800875 802741 804222 805212 805508 809282 809562 810265 813338 819794 825657 825723 827949 ] |
||||||||||||||||||||||||||||||
|
17.55 ms (11.37%) |
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 520493 447979 581962 400487 476326 532971 579322 802741 449335 465369 504567 463153 453688 489353 787309 612065 448924 460854 101065 800554 805508 631930 813338 439499 403003 459628 467413 399367 422751 526618 728348 742128 582777 544465 672506 672489 800875 810265 784393 730852 738371 748467 764919 804222 809282 809562 527439 532911 547061 613465 631980 757973 827949 502644 358438 120432 507178 784954 768351 457306 263144 229210 540759 442194 472447 647361 784932 819794 825723 825657 702401 396881 457288 477781 478223 463659 512538 711782 641689 395709 532945 468589 484095 470946 494371 188610 469412 776454 4510 624785 786431 7677 730272 644956 575525 687815 590360 590506 800344 798986 728244 732443 617730 620158 715707 787860 805212 411213 461428 480357 472832 720254 769924 748325 285162 389312 431682 673170 701819 788424 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.34%) |
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 4510 7677 101065 120432 188610 229210 263144 285162 358438 389312 395709 396881 399367 400487 403003 411213 422751 431682 439499 442194 447979 448924 449335 453688 457288 457306 459628 460854 461428 463153 463659 465369 467413 468589 469412 470946 472447 472832 476326 477781 478223 480357 484095 489353 494371 502644 504567 507178 512538 520493 526618 527439 532911 532945 532971 540759 544465 547061 575525 579322 581962 582777 590360 590506 612065 613465 617730 620158 624785 631930 631980 641689 644956 647361 672489 672506 673170 687815 701819 702401 711782 715707 720254 728244 728348 730272 730852 732443 738371 742128 748325 748467 757973 764919 768351 769924 776454 784393 784932 784954 786431 787309 787860 788424 798986 800344 800554 800875 802741 804222 805212 805508 809282 809562 810265 813338 819794 825657 825723 827949 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"redhead blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рыжая минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.