Query Metrics
7
Database Queries
7
Different statements
182.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.78 ms (84.23%) |
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 20031 21576 371547 391144 392393 396784 397714 398713 398920 400956 401440 402434 404339 408470 408770 410953 413258 413294 416441 417758 418699 420084 421122 421182 424952 425026 425757 426100 426463 427869 429169 429349 429947 433553 435799 436001 437676 440617 443463 444005 445577 446253 452621 454155 454660 454674 456524 456901 457030 459790 460080 460661 461519 461531 461582 461625 464688 464713 465754 465950 466197 467336 467384 469202 469898 470048 470341 470380 470530 473549 474615 475584 475608 476681 478554 480135 482258 483026 483259 484350 487086 489308 489584 492158 494359 494397 494499 495550 498603 498922 502047 502321 502720 502772 503892 504743 505186 505324 505494 506217 507983 508120 509765 512234 512259 513788 518951 519021 519281 520706 521368 521825 521934 522412 522820 525144 525216 527578 528275 529359 ] |
||||||||||||||||||||||||||||||
|
17.03 ms (9.33%) |
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 465754 465950 466197 467336 469202 473549 475584 20031 391144 396784 397714 398713 398920 400956 401440 417758 420084 421122 421182 426463 435799 443463 444005 446253 454674 456901 459790 461519 461625 464688 464713 467384 470341 474615 476681 480135 21576 371547 392393 402434 404339 408770 410953 413258 413294 416441 418699 426100 427869 429169 429349 429947 433553 437676 440617 445577 452621 454155 454660 457030 460661 461582 469898 470048 470380 478554 482258 408470 424952 425026 425757 436001 456524 460080 461531 470530 475608 502047 502321 502772 507983 518951 521825 522820 527578 484350 487086 489308 492158 494359 494397 494499 495550 498922 502720 505186 505324 505494 508120 509765 512259 513788 520706 522412 528275 483026 483259 489584 498603 503892 504743 506217 512234 519021 519281 521368 521934 525144 525216 529359 ] |
||||||||||||||||||||||||||||||
|
4.17 ms (2.29%) |
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 20031 21576 371547 391144 392393 396784 397714 398713 398920 400956 401440 402434 404339 408470 408770 410953 413258 413294 416441 417758 418699 420084 421122 421182 424952 425026 425757 426100 426463 427869 429169 429349 429947 433553 435799 436001 437676 440617 443463 444005 445577 446253 452621 454155 454660 454674 456524 456901 457030 459790 460080 460661 461519 461531 461582 461625 464688 464713 465754 465950 466197 467336 467384 469202 469898 470048 470341 470380 470530 473549 474615 475584 475608 476681 478554 480135 482258 483026 483259 484350 487086 489308 489584 492158 494359 494397 494499 495550 498603 498922 502047 502321 502720 502772 503892 504743 505186 505324 505494 506217 507983 508120 509765 512234 512259 513788 518951 519021 519281 520706 521368 521825 521934 522412 522820 525144 525216 527578 528275 529359 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"xxx beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"xxx красивая"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"xxx красивая"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.87%) |
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.