Query Metrics
7
Database Queries
7
Different statements
196.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.89 ms (86.79%) |
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 388543 390931 395699 396862 398178 400179 401014 401226 401621 403031 407288 407346 409109 409224 412620 413097 413111 416407 417008 418520 420407 421132 422299 427452 428468 428881 433070 437582 438199 438208 445914 446277 449243 450773 451880 452629 453540 454043 459143 460166 464144 464412 465834 469487 471408 478992 479019 484768 490167 492115 498501 499333 507834 513114 519821 519934 519938 520687 520691 520693 522168 522614 523323 524271 524651 524867 525720 527449 529305 531523 531528 531935 532114 536347 556607 556659 561568 562884 562987 565004 573749 579227 579284 579761 581893 584395 587685 590735 594925 596488 610343 611389 619775 621235 630630 651216 684030 687195 710568 715662 716935 740156 744187 758564 765023 765045 770494 772612 775414 777792 780340 782626 789525 796206 799645 802188 805715 807369 807636 820337 ] |
||||||||||||||||||||||||||||||
|
17.08 ms (8.68%) |
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 777792 412620 454043 519938 556607 459143 398178 407346 420407 438199 445914 492115 520691 527449 413097 464144 449243 519821 715662 684030 775414 782626 772612 390931 401621 407288 413111 453540 469487 471408 421132 464412 451880 433070 438208 490167 519934 520693 395699 446277 525720 802188 807369 770494 796206 805715 807636 740156 765023 780340 799645 417008 396862 401014 427452 437582 452629 460166 478992 522614 513114 524271 428468 450773 524651 687195 651216 716935 611389 765045 744187 400179 428881 820337 562987 579761 584395 561568 562884 594925 630630 587685 596488 590735 418520 422299 403031 520687 536347 498501 416407 507834 523323 409109 524867 579284 479019 401226 465834 484768 529305 522168 565004 581893 556659 579227 758564 710568 388543 409224 499333 531523 531528 532114 531935 573749 619775 621235 610343 789525 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.31%) |
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 388543 390931 395699 396862 398178 400179 401014 401226 401621 403031 407288 407346 409109 409224 412620 413097 413111 416407 417008 418520 420407 421132 422299 427452 428468 428881 433070 437582 438199 438208 445914 446277 449243 450773 451880 452629 453540 454043 459143 460166 464144 464412 465834 469487 471408 478992 479019 484768 490167 492115 498501 499333 507834 513114 519821 519934 519938 520687 520691 520693 522168 522614 523323 524271 524651 524867 525720 527449 529305 531523 531528 531935 532114 536347 556607 556659 561568 562884 562987 565004 573749 579227 579284 579761 581893 584395 587685 590735 594925 596488 610343 611389 619775 621235 630630 651216 684030 687195 710568 715662 716935 740156 744187 758564 765023 765045 770494 772612 775414 777792 780340 782626 789525 796206 799645 802188 805715 807369 807636 820337 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big as mom"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие mom"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие mom"
]
|
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.