Query Metrics
7
Database Queries
7
Different statements
167.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.61 ms (84.67%) |
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 7161 14216 14225 14700 14711 14806 14853 20031 25069 32485 44174 78620 78942 102511 102702 108018 120061 123921 156920 161342 161358 161887 162212 178567 180923 191599 195513 260041 309223 312466 318228 381432 382411 383477 384461 385841 385908 386492 387524 390089 390318 390499 392797 394713 395400 395428 395502 395536 396567 396581 396710 396726 396742 398045 398140 399015 399273 399356 399396 399405 399717 399757 400668 401509 402967 403160 404230 404426 405147 405808 406513 408074 413745 414001 414066 414108 414146 415872 417240 417824 417829 418452 419104 420250 424866 425164 425358 430298 431772 433995 435662 446350 446351 449353 452114 456997 457796 458597 465190 467030 468126 468485 468628 468788 472448 474063 475326 475821 486229 486551 489166 493805 496308 499743 507150 527888 529887 538421 590329 656768 ] |
||||||||||||||||||||||||||||||
|
15.54 ms (9.29%) |
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 418452 399396 433995 382411 398140 408074 472448 162212 405808 404426 468126 161342 383477 396742 527888 468628 156920 25069 309223 390318 403160 435662 414146 417240 381432 396710 425164 475326 406513 457796 318228 399015 260041 417824 452114 486551 399356 399757 456997 78942 529887 102702 417829 14853 396567 120061 399405 180923 493805 390499 414066 398045 399273 399717 191599 395428 449353 385908 7161 14225 431772 446351 395502 420250 424866 507150 392797 385841 78620 414108 415872 465190 178567 14216 390089 395536 401509 161358 312466 14711 387524 446350 108018 395400 425358 499743 102511 32485 402967 400668 14806 386492 404230 496308 384461 413745 458597 394713 538421 486229 590329 44174 430298 467030 468485 475821 161887 468788 414001 474063 489166 20031 656768 195513 123921 14700 396726 396581 405147 419104 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (1.91%) |
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 7161 14216 14225 14700 14711 14806 14853 20031 25069 32485 44174 78620 78942 102511 102702 108018 120061 123921 156920 161342 161358 161887 162212 178567 180923 191599 195513 260041 309223 312466 318228 381432 382411 383477 384461 385841 385908 386492 387524 390089 390318 390499 392797 394713 395400 395428 395502 395536 396567 396581 396710 396726 396742 398045 398140 399015 399273 399356 399396 399405 399717 399757 400668 401509 402967 403160 404230 404426 405147 405808 406513 408074 413745 414001 414066 414108 414146 415872 417240 417824 417829 418452 419104 420250 424866 425164 425358 430298 431772 433995 435662 446350 446351 449353 452114 456997 457796 458597 465190 467030 468126 468485 468628 468788 472448 474063 475326 475821 486229 486551 489166 493805 496308 499743 507150 527888 529887 538421 590329 656768 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex negro"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс чернокожий"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.89%) |
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.