Query Metrics
7
Database Queries
7
Different statements
200.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.42 ms (85.13%) |
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 187704 233570 340567 386384 389680 391669 397880 397916 411015 411326 411417 411930 422349 423775 424090 424317 424444 428393 429902 439645 439650 439750 440339 440445 440824 443085 443820 444104 445208 448679 451462 454546 456389 460804 460864 460924 461932 463087 465902 465907 466186 466241 468113 468182 468815 468916 469164 469167 470031 470402 470502 470615 471113 473908 473960 476267 476838 478057 479051 479061 479087 479121 480902 481923 485366 485638 485974 486126 490126 491913 492167 492660 493316 494215 503494 512745 513538 514366 515707 519452 522092 523733 525839 526300 527836 529516 530005 531524 534119 542753 544502 547805 548907 552375 556338 558928 560008 563152 566421 573175 582576 591130 591213 600023 601487 603437 609071 620251 651822 677861 705408 720511 738331 746580 761517 769133 782230 788100 795202 825764 ] |
||||||||||||||||||||||||||||||
|
19.81 ms (9.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 470615 519452 529516 582576 494215 677861 601487 761517 469167 397880 470402 476838 552375 547805 411015 424444 466186 479121 460804 473908 513538 486126 485366 485974 492167 769133 465902 479087 480902 440445 591130 481923 439645 460924 471113 479051 566421 424090 525839 542753 573175 445208 600023 544502 591213 397916 490126 470502 233570 558928 651822 788100 795202 746580 738331 705408 531524 444104 391669 476267 422349 620251 411930 473960 515707 411326 491913 187704 825764 603437 468916 454546 720511 782230 463087 461932 534119 522092 548907 560008 563152 609071 424317 451462 468182 423775 439750 465907 340567 456389 460864 468113 527836 523733 448679 503494 530005 411417 526300 469164 389680 514366 439650 440824 479061 428393 468815 478057 466241 512745 429902 470031 386384 443085 485638 556338 440339 443820 493316 492660 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.28%) |
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 187704 233570 340567 386384 389680 391669 397880 397916 411015 411326 411417 411930 422349 423775 424090 424317 424444 428393 429902 439645 439650 439750 440339 440445 440824 443085 443820 444104 445208 448679 451462 454546 456389 460804 460864 460924 461932 463087 465902 465907 466186 466241 468113 468182 468815 468916 469164 469167 470031 470402 470502 470615 471113 473908 473960 476267 476838 478057 479051 479061 479087 479121 480902 481923 485366 485638 485974 486126 490126 491913 492167 492660 493316 494215 503494 512745 513538 514366 515707 519452 522092 523733 525839 526300 527836 529516 530005 531524 534119 542753 544502 547805 548907 552375 556338 558928 560008 563152 566421 573175 582576 591130 591213 600023 601487 603437 609071 620251 651822 677861 705408 720511 738331 746580 761517 769133 782230 788100 795202 825764 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русские мамы чулки"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск мам женщин чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.81%) |
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.