Query Metrics
7
Database Queries
7
Different statements
141.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.69 ms (82.66%) |
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 20322 93079 122425 146414 163006 163762 166675 167822 167923 285321 298320 315072 327121 383735 385480 386724 387597 387720 388222 390614 391358 397045 397072 402062 404841 405786 407382 419140 419157 420025 420216 420252 420818 421360 422754 424740 425300 426171 429341 429543 429547 430392 431427 431850 432337 434439 446476 447826 448103 448357 456862 457100 457248 460577 460931 463747 464714 465076 467705 477403 482237 482330 483551 495866 496107 501252 503248 507670 510266 510582 510589 512172 512208 512210 512216 512223 515703 520151 523222 524492 525197 535992 550617 550618 550641 550735 550762 550778 551012 551976 552012 552029 552036 552054 552281 552899 552905 552927 554428 556390 557512 557537 557543 559925 563880 565479 565986 565995 565998 582669 583255 585812 586635 588115 595819 623499 652547 673044 714119 786333 ] |
||||||||||||||||||||||||||||||
|
16.31 ms (11.56%) |
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 420025 523222 512172 673044 786333 524492 20322 405786 512208 391358 585812 588115 496107 550618 431850 550735 623499 552012 477403 383735 432337 495866 507670 404841 327121 714119 425300 163006 387597 550617 167822 460577 388222 434439 551012 167923 565995 550778 652547 559925 429547 385480 457100 407382 465076 285321 556390 429341 298320 552905 460931 552036 163762 565479 512210 550641 166675 421360 429543 512223 583255 390614 457248 535992 552927 386724 419140 430392 582669 387720 557537 456862 557543 463747 552054 552029 510266 510589 482237 565986 448357 515703 146414 424740 447826 402062 552899 512216 93079 397072 422754 565998 419157 510582 557512 563880 586635 397045 503248 420252 448103 551976 482330 525197 122425 595819 431427 501252 520151 420216 464714 315072 483551 467705 554428 426171 420818 446476 552281 550762 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.96%) |
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 20322 93079 122425 146414 163006 163762 166675 167822 167923 285321 298320 315072 327121 383735 385480 386724 387597 387720 388222 390614 391358 397045 397072 402062 404841 405786 407382 419140 419157 420025 420216 420252 420818 421360 422754 424740 425300 426171 429341 429543 429547 430392 431427 431850 432337 434439 446476 447826 448103 448357 456862 457100 457248 460577 460931 463747 464714 465076 467705 477403 482237 482330 483551 495866 496107 501252 503248 507670 510266 510582 510589 512172 512208 512210 512216 512223 515703 520151 523222 524492 525197 535992 550617 550618 550641 550735 550762 550778 551012 551976 552012 552029 552036 552054 552281 552899 552905 552927 554428 556390 557512 557537 557543 559925 563880 565479 565986 565995 565998 582669 583255 585812 586635 588115 595819 623499 652547 673044 714119 786333 ] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boy japanese"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.33 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парен японк азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.15 ms (0.81%) |
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.