Query Metrics
7
Database Queries
7
Different statements
183.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.57 ms (83.65%) |
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 188437 191398 370794 382413 385388 391394 391703 391923 391950 392930 392956 396397 397621 400478 400481 401480 403321 408278 411345 411360 411848 413075 414871 415342 420254 420473 421899 422819 423494 424123 439454 439727 441353 441406 441838 446522 454171 454508 455995 459635 460486 462557 463991 464361 467109 475682 480497 483456 503834 504665 516028 536473 544793 549836 551473 583992 602293 610062 620508 652992 700061 709285 712693 715543 717621 718611 724039 725207 725475 727445 727507 732597 733116 733130 733155 736219 736894 739608 739925 739950 739985 741559 742561 742763 743800 745516 745966 748391 749109 758151 761164 765464 765493 765669 766636 768366 769311 774427 774605 781913 781992 788568 795962 795984 796112 797191 797461 800402 807995 823736 824517 824837 824845 825069 826161 826389 826701 828145 828494 828605 ] |
||||||||||||||||||||||||||||||
|
19.31 ms (10.52%) |
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 795984 736894 724039 727507 739925 739950 742561 748391 749109 765464 768366 743800 736219 739608 742763 761164 610062 709285 717621 774605 795962 796112 391923 391950 483456 188437 391703 392956 828145 551473 788568 745516 758151 700061 825069 826161 823736 826389 824517 828494 828605 718611 741559 385388 391394 413075 774427 826701 824845 824837 583992 712693 715543 652992 544793 620508 781913 733155 781992 807995 732597 725207 733130 745966 727445 765669 733116 766636 422819 463991 420254 392930 397621 401480 441353 441406 441838 408278 423494 439454 454171 464361 460486 467109 459635 602293 800402 769311 797191 797461 725475 739985 765493 424123 396397 400478 400481 439727 455995 370794 411360 411848 414871 420473 446522 504665 503834 516028 475682 549836 403321 480497 454508 462557 536473 191398 382413 415342 411345 421899 ] |
||||||||||||||||||||||||||||||
|
3.41 ms (1.85%) |
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 188437 191398 370794 382413 385388 391394 391703 391923 391950 392930 392956 396397 397621 400478 400481 401480 403321 408278 411345 411360 411848 413075 414871 415342 420254 420473 421899 422819 423494 424123 439454 439727 441353 441406 441838 446522 454171 454508 455995 459635 460486 462557 463991 464361 467109 475682 480497 483456 503834 504665 516028 536473 544793 549836 551473 583992 602293 610062 620508 652992 700061 709285 712693 715543 717621 718611 724039 725207 725475 727445 727507 732597 733116 733130 733155 736219 736894 739608 739925 739950 739985 741559 742561 742763 743800 745516 745966 748391 749109 758151 761164 765464 765493 765669 766636 768366 769311 774427 774605 781913 781992 788568 795962 795984 796112 797191 797461 800402 807995 823736 824517 824837 824845 825069 826161 826389 826701 828145 828494 828605 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother chubby"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин chubby"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин chubby"
]
|
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.