Query Metrics
7
Database Queries
7
Different statements
230.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.53 ms (88.64%) |
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 155175 305464 346122 357442 381823 386589 387412 387467 388805 389019 389541 389964 392076 396390 396439 396809 398558 398991 400950 403871 418132 418780 419201 423751 426298 426637 426897 429484 435618 436885 437950 444081 446760 449104 449421 449572 449573 452743 452997 456252 458549 461663 462985 465223 465319 465796 466703 468316 468853 469427 469827 472194 473454 473786 474985 475767 478626 480931 482302 483723 483735 484066 484938 484947 486247 489115 489881 491102 492424 493339 496418 501707 502472 503889 504213 507332 512371 512591 517389 519422 520277 521268 522328 522525 525489 527847 531297 532498 534135 538559 540403 542757 545869 558172 559430 564954 575357 592656 616246 624351 640184 665974 671518 671545 701278 730836 733508 763448 785255 793049 794749 809873 818145 819820 823460 823815 823852 826570 ] |
||||||||||||||||||||||||||||||
|
15.93 ms (6.90%) |
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 484947 520277 496418 517389 519422 545869 387412 818145 823815 819820 823460 794749 763448 398991 387467 823852 826077 825816 826570 542757 305464 474985 701278 665974 640184 809873 793049 730836 733508 616246 449104 501707 472194 558172 559430 483735 484066 527847 491102 522328 522525 504213 386589 155175 392076 346122 381823 357442 389019 389541 389964 388805 396439 396809 396390 398558 400950 403871 419201 426298 444081 426637 426897 429484 435618 436885 437950 418132 418780 423751 446760 452997 456252 465223 466703 468316 468853 473786 475767 489881 449421 449572 449573 452743 461663 469827 473454 483723 486247 458549 462985 465796 469427 478626 480931 484938 492424 512591 521268 538559 540403 532498 502472 534135 503889 507332 512371 525489 531297 465319 482302 489115 493339 564954 575357 671518 671545 592656 624351 785255 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.18%) |
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 155175 305464 346122 357442 381823 386589 387412 387467 388805 389019 389541 389964 392076 396390 396439 396809 398558 398991 400950 403871 418132 418780 419201 423751 426298 426637 426897 429484 435618 436885 437950 444081 446760 449104 449421 449572 449573 452743 452997 456252 458549 461663 462985 465223 465319 465796 466703 468316 468853 469427 469827 472194 473454 473786 474985 475767 478626 480931 482302 483723 483735 484066 484938 484947 486247 489115 489881 491102 492424 493339 496418 501707 502472 503889 504213 507332 512371 512591 517389 519422 520277 521268 522328 522525 525489 527847 531297 532498 534135 538559 540403 542757 545869 558172 559430 564954 575357 592656 616246 624351 640184 665974 671518 671545 701278 730836 733508 763448 785255 793049 794749 809873 818145 819820 823460 823815 823852 826570 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер жен"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam wife"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер жен"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.73%) |
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.