Query Metrics
7
Database Queries
7
Different statements
148.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.28 ms (84.80%) |
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 33236 69611 154491 155198 383011 383933 393660 395989 396711 399038 399255 402350 403293 404360 405508 410076 411052 414101 415155 417495 417825 419998 432105 437517 441901 445973 449161 454331 458202 461738 462802 465700 467110 468789 477082 483587 489347 493001 496308 499556 509149 510017 510330 512120 519766 519862 526095 529634 536570 536930 537832 538725 540528 545475 548588 554797 557749 558171 560292 565098 566242 568257 580614 580757 589238 590165 591162 593104 598504 602061 602894 607101 607152 607215 608516 617130 620487 623963 624831 630913 637077 638477 660365 663321 666490 674100 683593 695464 704184 704185 709885 710266 710872 718947 719243 720186 724841 725115 730466 732468 738855 740268 740965 741296 742163 744607 745111 768692 785552 785580 789790 796629 796871 797051 803374 807847 812738 814130 814459 823030 ] |
||||||||||||||||||||||||||||||
|
12.96 ms (8.70%) |
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 33236 405508 383011 155198 396711 399038 402350 403293 411052 417825 410076 432105 814130 462802 483587 454331 468789 489347 510017 512120 519766 499556 536930 537832 540528 560292 565098 683593 674100 704184 710266 710872 719243 660365 704185 566242 591162 590165 589238 602894 630913 638477 796871 807847 789790 796629 803374 742163 744607 741296 745111 732468 768692 724841 740965 620487 797051 812738 417495 458202 461738 395989 419998 445973 465700 509149 496308 545475 399255 404360 441901 785580 415155 510330 383933 69611 437517 814459 477082 449161 493001 536570 526095 558171 568257 666490 695464 718947 720186 580614 624831 598504 617130 730466 725115 740268 738855 607215 709885 154491 393660 414101 823030 467110 519862 529634 538725 548588 554797 557749 663321 580757 623963 607152 602061 607101 593104 608516 637077 785552 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (2.15%) |
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 33236 69611 154491 155198 383011 383933 393660 395989 396711 399038 399255 402350 403293 404360 405508 410076 411052 414101 415155 417495 417825 419998 432105 437517 441901 445973 449161 454331 458202 461738 462802 465700 467110 468789 477082 483587 489347 493001 496308 499556 509149 510017 510330 512120 519766 519862 526095 529634 536570 536930 537832 538725 540528 545475 548588 554797 557749 558171 560292 565098 566242 568257 580614 580757 589238 590165 591162 593104 598504 602061 602894 607101 607152 607215 608516 617130 620487 623963 624831 630913 637077 638477 660365 663321 666490 674100 683593 695464 704184 704185 709885 710266 710872 718947 719243 720186 724841 725115 730466 732468 738855 740268 740965 741296 742163 744607 745111 768692 785552 785580 789790 796629 796871 797051 803374 807847 812738 814130 814459 823030 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black black girls"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black black девушк"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black black девушк"
]
|
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.