Query Metrics
7
Database Queries
7
Different statements
145.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.41 ms (83.02%) |
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 96872 151062 397656 398354 402950 409939 419998 421571 424216 432776 435411 437863 437999 439156 441850 456664 461707 464705 464837 464901 465172 465320 465923 468348 468402 468434 474913 474969 477597 478073 479528 481409 489014 493610 494448 497732 504322 506115 516737 519722 528315 528853 530448 533745 542151 555110 555170 566405 573270 576560 577576 579842 584402 589067 589472 590361 591206 592955 596796 598272 601728 604168 604363 606346 610540 620234 620238 620259 625942 626256 634602 645669 656498 662022 672269 679652 683028 685819 686133 686457 695343 695351 705449 707210 710510 712770 719957 720174 723153 724074 724853 726314 728334 732262 732346 734324 735554 737015 742348 759502 761495 767098 772517 776310 778541 787492 790542 790976 796132 797191 800896 802747 803394 804309 814333 814457 817273 817546 826453 826503 ] |
||||||||||||||||||||||||||||||
|
14.55 ms (10.03%) |
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 151062 398354 814333 468434 474913 479528 461707 465320 497732 528853 519722 506115 566405 577576 645669 719957 576560 591206 604363 604168 606346 610540 596796 598272 776310 803394 759502 761495 772517 797191 728334 742348 620234 474969 516737 504322 397656 817546 481409 686133 672269 685819 686457 695343 589067 732346 737015 620238 787492 441850 419998 435411 735554 421571 96872 814457 826503 555170 707210 705449 662022 679652 712770 590361 790976 802747 790542 726314 724074 767098 778541 800896 402950 584402 683028 626256 634602 494448 695351 625942 555110 437863 468348 465923 530448 724853 826453 439156 409939 817273 465172 533745 528315 464705 489014 710510 723153 589472 620259 796132 732262 804309 734324 720174 424216 437999 478073 493610 477597 464901 432776 468402 456664 464837 573270 542151 656498 579842 592955 601728 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (2.14%) |
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 96872 151062 397656 398354 402950 409939 419998 421571 424216 432776 435411 437863 437999 439156 441850 456664 461707 464705 464837 464901 465172 465320 465923 468348 468402 468434 474913 474969 477597 478073 479528 481409 489014 493610 494448 497732 504322 506115 516737 519722 528315 528853 530448 533745 542151 555110 555170 566405 573270 576560 577576 579842 584402 589067 589472 590361 591206 592955 596796 598272 601728 604168 604363 606346 610540 620234 620238 620259 625942 626256 634602 645669 656498 662022 672269 679652 683028 685819 686133 686457 695343 695351 705449 707210 710510 712770 719957 720174 723153 724074 724853 726314 728334 732262 732346 734324 735554 737015 742348 759502 761495 767098 772517 776310 778541 787492 790542 790976 796132 797191 800896 802747 803394 804309 814333 814457 817273 817546 826453 826503 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife hard anal"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен hard анал"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен hard анал"
]
|
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.