Query Metrics
7
Database Queries
7
Different statements
159.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.90 ms (86.84%) |
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 205011 313994 383984 386179 387777 389516 393347 401482 406017 406445 409646 410235 410688 414849 416988 420032 420140 429602 437561 438533 441698 450251 451732 452361 453513 460524 467986 469743 473185 475485 478038 488558 489853 495042 498698 498837 508758 510006 510060 511811 518897 533028 533944 543418 543427 551288 551289 551422 554981 555859 561426 568281 569820 574688 574890 575730 575801 575935 592364 595572 602597 609794 610851 614049 615923 618319 622644 629008 630252 633088 636515 636960 643436 643784 644675 648518 651932 654137 654152 658706 661107 663061 663077 666347 667306 669110 669136 669546 670162 671580 692104 697521 702546 712726 720540 738419 738893 741245 747345 754193 762368 770609 773172 773215 777258 778129 793001 802786 814980 816830 817486 818254 818784 819229 823316 823885 825930 825964 827275 ] |
||||||||||||||||||||||||||||||
|
11.29 ms (7.06%) |
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 393347 817486 818254 818784 702546 712726 663077 669110 671580 551288 610851 614049 773172 383984 478038 609794 437561 401482 205011 313994 387777 410235 814980 823316 489853 574688 697521 420032 451732 406017 409646 416988 495042 518897 488558 498837 533944 825930 827275 819229 533028 666347 669546 658706 692104 648518 654137 654152 661107 670162 602597 633088 643436 738419 741245 770609 738893 747345 754193 762368 622644 630252 644675 575935 816830 825964 778129 406445 823885 543427 663061 667306 669136 651932 720540 629008 618319 636960 636515 802786 777258 793001 769790 773215 643784 386179 410688 414849 429602 438533 420140 595572 452361 475485 467986 473185 450251 498698 511811 508758 510060 510006 460524 469743 551289 561426 568281 569820 574890 575730 543418 551422 554981 575801 555859 615923 592364 389516 441698 453513 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.76%) |
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 205011 313994 383984 386179 387777 389516 393347 401482 406017 406445 409646 410235 410688 414849 416988 420032 420140 429602 437561 438533 441698 450251 451732 452361 453513 460524 467986 469743 473185 475485 478038 488558 489853 495042 498698 498837 508758 510006 510060 511811 518897 533028 533944 543418 543427 551288 551289 551422 554981 555859 561426 568281 569820 574688 574890 575730 575801 575935 592364 595572 602597 609794 610851 614049 615923 618319 622644 629008 630252 633088 636515 636960 643436 643784 644675 648518 651932 654137 654152 658706 661107 663061 663077 666347 667306 669110 669136 669546 670162 671580 692104 697521 702546 712726 720540 738419 738893 741245 747345 754193 762368 770609 773172 773215 777258 778129 793001 802786 814980 816830 817486 818254 818784 819229 823316 823885 825930 825964 827275 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"oil girl"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"масл девушк"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.92%) |
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.