Query Metrics
7
Database Queries
7
Different statements
154.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.44 ms (82.60%) |
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 188062 188556 202902 383160 385092 395609 395682 396670 397508 397982 398934 399857 400482 401130 404994 405123 406471 408383 411255 411354 411717 411736 413381 415761 419320 419541 419871 422575 422923 424314 424884 424927 425121 425886 426159 428269 428778 432574 432883 433276 433493 434374 435131 435599 436139 437044 437084 439440 439808 439824 441027 441448 443994 444502 445393 445896 447121 447453 448537 448542 448860 451253 451557 451595 452010 452059 452575 455407 455866 456273 456313 456951 458623 458770 458912 461364 462908 464124 465379 465537 465879 467700 467907 468046 468743 469223 470211 470864 470931 472206 472317 473989 474264 475056 475836 475911 476785 478466 478575 484057 485435 486776 490244 492597 495158 498003 501749 504482 506170 510814 518446 522900 522910 525954 567198 578714 595518 622682 653487 744517 ] |
||||||||||||||||||||||||||||||
|
17.09 ms (11.08%) |
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 473989 444502 455407 465537 470211 397982 451557 411354 422923 501749 484057 504482 498003 518446 744517 408383 411717 422575 433493 424314 470864 439808 525954 397508 432574 437084 456951 468046 468743 522900 653487 415761 435131 395682 437044 445393 461364 398934 432883 419541 470931 478466 451595 456273 456313 522910 510814 495158 385092 383160 188062 188556 404994 411736 413381 419320 419871 424884 436139 428269 441027 472317 475836 458770 451253 452010 458623 462908 465379 475056 486776 467700 578714 567198 595518 622682 406471 396670 399857 405123 452059 455866 458912 467907 439440 447121 395609 428778 435599 439824 465879 476785 424927 469223 474264 485435 506170 492597 202902 401130 411255 425886 426159 433276 441448 443994 425121 448537 445896 478575 448542 490244 464124 472206 400482 434374 447453 448860 452575 475911 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (2.05%) |
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 188062 188556 202902 383160 385092 395609 395682 396670 397508 397982 398934 399857 400482 401130 404994 405123 406471 408383 411255 411354 411717 411736 413381 415761 419320 419541 419871 422575 422923 424314 424884 424927 425121 425886 426159 428269 428778 432574 432883 433276 433493 434374 435131 435599 436139 437044 437084 439440 439808 439824 441027 441448 443994 444502 445393 445896 447121 447453 448537 448542 448860 451253 451557 451595 452010 452059 452575 455407 455866 456273 456313 456951 458623 458770 458912 461364 462908 464124 465379 465537 465879 467700 467907 468046 468743 469223 470211 470864 470931 472206 472317 473989 474264 475056 475836 475911 476785 478466 478575 484057 485435 486776 490244 492597 495158 498003 501749 504482 506170 510814 518446 522900 522910 525954 567198 578714 595518 622682 653487 744517 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в тугую"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в туг"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.95%) |
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.