Query Metrics
7
Database Queries
7
Different statements
189.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.10 ms (82.46%) |
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 382207 383287 390650 394212 395628 398038 401773 403087 407753 409083 409226 410439 411626 412521 413164 413268 416063 417308 418853 418905 419565 419956 420219 425611 426006 428410 428752 428884 429899 430293 433968 437559 437679 442114 442836 443786 445474 445498 445874 446644 446855 447740 447937 448319 448837 449623 452353 452446 452968 453091 453390 453550 454271 454327 454565 456127 458278 459476 460192 460195 460921 460954 462126 462817 463942 464022 464023 464601 464667 465214 465431 466392 466709 466995 468100 468228 468927 468946 470612 470679 471647 472198 472216 473247 473400 473634 474124 474226 475685 476237 476310 478063 481914 484923 486814 487347 489087 492192 492462 494547 494833 499829 502108 505253 505397 507181 510425 518868 518873 519309 561077 563166 567527 578528 585851 610228 613015 666188 726876 728956 ] |
||||||||||||||||||||||||||||||
|
22.63 ms (11.95%) |
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 437679 409226 445874 452968 462817 561077 428884 466995 417308 463942 459476 489087 518873 468927 383287 390650 403087 411626 425611 430293 426006 433968 418905 428410 445474 447937 448319 465214 468228 474124 456127 471647 452446 464022 466709 472216 475685 478063 484923 502108 505253 505397 518868 494547 499829 460192 460195 476310 567527 613015 728956 726876 413268 453091 454565 462126 473247 395628 470612 474226 458278 473634 449623 452353 464667 470679 486814 429899 442114 419956 466392 481914 453550 563166 464023 473400 454271 465431 510425 519309 382207 398038 401773 410439 412521 416063 420219 413164 418853 419565 428752 442836 445498 460954 468100 487347 492192 448837 454327 464601 468946 472198 476237 492462 446644 446855 447740 494833 507181 578528 666188 585851 610228 407753 409083 453390 394212 443786 460921 437559 ] |
||||||||||||||||||||||||||||||
|
3.53 ms (1.87%) |
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 382207 383287 390650 394212 395628 398038 401773 403087 407753 409083 409226 410439 411626 412521 413164 413268 416063 417308 418853 418905 419565 419956 420219 425611 426006 428410 428752 428884 429899 430293 433968 437559 437679 442114 442836 443786 445474 445498 445874 446644 446855 447740 447937 448319 448837 449623 452353 452446 452968 453091 453390 453550 454271 454327 454565 456127 458278 459476 460192 460195 460921 460954 462126 462817 463942 464022 464023 464601 464667 465214 465431 466392 466709 466995 468100 468228 468927 468946 470612 470679 471647 472198 472216 473247 473400 473634 474124 474226 475685 476237 476310 478063 481914 484923 486814 487347 489087 492192 492462 494547 494833 499829 502108 505253 505397 507181 510425 518868 518873 519309 561077 563166 567527 578528 585851 610228 613015 666188 726876 728956 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"толстуха с волосатой %…"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"толстая волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.24 ms (0.65%) |
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.