Query Metrics
7
Database Queries
7
Different statements
180.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.30 ms (86.69%) |
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 6666 14216 14700 14806 32485 44174 69611 78824 80900 102511 102702 120074 122425 123921 143010 161887 195513 271293 325432 382025 382468 382485 382591 383311 384461 384811 385080 385855 386492 387565 388023 388855 389640 390032 390089 390306 390746 392797 394713 394931 395398 395400 395506 395536 396561 396581 396706 396718 396726 396729 397656 398045 399273 399303 399332 399378 399717 399737 400668 401509 402574 402967 404230 404247 405147 405508 408196 408464 408528 411001 413745 414001 417825 417829 418061 419104 419876 424773 424866 424901 425358 427176 429970 430278 430298 430750 430770 432105 437517 443037 443332 445086 453194 455116 457828 458597 461718 467030 468485 468556 468561 468788 473098 474063 475821 482822 486229 490589 496277 496308 499743 505097 507150 525345 529441 530629 538421 590329 655358 656768 ] |
||||||||||||||||||||||||||||||
|
14.44 ms (8.01%) |
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 395400 424866 430770 102702 398045 399273 404247 425358 455116 457828 499743 507150 417829 655358 656768 399717 80900 384461 102511 143010 44174 32485 14216 388855 390089 397656 402967 417825 413745 427176 430298 432105 429970 430278 443037 467030 468561 453194 482822 458597 468485 475821 496277 505097 461718 468556 161887 382468 395536 400668 468788 14806 385080 386492 390746 392797 404230 414001 388023 401509 405508 394713 473098 474063 529441 525345 530629 538421 490589 496308 590329 486229 385855 69611 78824 384811 383311 195513 120074 122425 123921 394931 395398 395506 271293 325432 382485 382025 382591 6666 14700 389640 390032 390306 387565 396561 396726 396706 396581 396718 396729 399737 399378 399303 399332 402574 405147 408196 408528 411001 424901 445086 408464 418061 430750 437517 443332 419104 419876 424773 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.62%) |
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 6666 14216 14700 14806 32485 44174 69611 78824 80900 102511 102702 120074 122425 123921 143010 161887 195513 271293 325432 382025 382468 382485 382591 383311 384461 384811 385080 385855 386492 387565 388023 388855 389640 390032 390089 390306 390746 392797 394713 394931 395398 395400 395506 395536 396561 396581 396706 396718 396726 396729 397656 398045 399273 399303 399332 399378 399717 399737 400668 401509 402574 402967 404230 404247 405147 405508 408196 408464 408528 411001 413745 414001 417825 417829 418061 419104 419876 424773 424866 424901 425358 427176 429970 430278 430298 430750 430770 432105 437517 443037 443332 445086 453194 455116 457828 458597 461718 467030 468485 468556 468561 468788 473098 474063 475821 482822 486229 490589 496277 496308 499743 505097 507150 525345 529441 530629 538421 590329 655358 656768 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"с негру"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чернокожий"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.28 ms (0.71%) |
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.