Query Metrics
7
Database Queries
7
Different statements
201.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.33 ms (84.14%) |
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 96665 118226 285321 338587 382176 385342 385448 390368 393734 395587 395703 401099 403064 404939 405088 405494 405925 406377 407024 410402 411675 411688 416303 417308 417836 419220 419839 419947 420218 421550 424703 427494 442198 443793 446041 446079 446536 448319 450455 451243 451890 452080 454065 456400 457674 457963 458523 460289 460965 461315 464162 464326 464388 467050 468897 469379 469576 469579 470991 473400 473525 477444 477934 479063 479722 485942 490517 491208 502108 504559 506061 509253 513143 515347 518493 518873 519633 521363 525149 526267 527196 527888 527968 539336 550354 555433 559692 560672 560673 561602 566981 568601 571468 574204 574380 578175 580271 581696 592686 593988 595362 596409 598696 620371 620912 623473 623840 630015 669593 681223 696812 709369 716069 804751 815574 815888 817064 818484 819182 827299 ] |
||||||||||||||||||||||||||||||
|
21.91 ms (10.89%) |
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 450455 442198 446536 417308 419947 527968 817064 815888 539336 451243 457674 457963 393734 424703 491208 338587 385448 419839 560672 395703 405088 506061 458523 464326 411675 593988 419220 623840 417836 446079 681223 620371 804751 461315 427494 568601 580271 581696 571468 598696 446041 473400 469576 401099 410402 421550 827299 448319 502108 561602 592686 595362 596409 456400 521363 96665 385342 118226 285321 382176 390368 405925 407024 818484 815574 819182 479722 513143 519633 525149 560673 555433 566981 669593 574380 623473 630015 620912 709369 395587 467050 477934 504559 509253 527196 420218 405494 460965 477444 578175 696812 716069 403064 406377 411688 473525 485942 490517 470991 451890 464388 469579 479063 550354 443793 469379 468897 518873 404939 452080 454065 526267 464162 574204 559692 416303 460289 527888 518493 515347 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.48%) |
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 96665 118226 285321 338587 382176 385342 385448 390368 393734 395587 395703 401099 403064 404939 405088 405494 405925 406377 407024 410402 411675 411688 416303 417308 417836 419220 419839 419947 420218 421550 424703 427494 442198 443793 446041 446079 446536 448319 450455 451243 451890 452080 454065 456400 457674 457963 458523 460289 460965 461315 464162 464326 464388 467050 468897 469379 469576 469579 470991 473400 473525 477444 477934 479063 479722 485942 490517 491208 502108 504559 506061 509253 513143 515347 518493 518873 519633 521363 525149 526267 527196 527888 527968 539336 550354 555433 559692 560672 560673 561602 566981 568601 571468 574204 574380 578175 580271 581696 592686 593988 595362 596409 598696 620371 620912 623473 623840 630015 669593 681223 696812 709369 716069 804751 815574 815888 817064 818484 819182 827299 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy man ass"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая мужчин жоп"
]
|
||||||||||||||||||||||||||||||
|
1.42 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.