Query Metrics
7
Database Queries
7
Different statements
180.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.76 ms (85.32%) |
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 14599 154491 155198 382217 391690 393660 395989 396575 396704 396711 399038 402350 403293 409066 410076 411052 414101 417495 417825 419600 419998 423790 429358 430380 432105 445973 454331 458202 461738 461755 462802 465700 467110 468475 468789 478773 479703 483587 489347 496308 499556 508843 509149 510017 512120 519862 526453 529634 529664 530304 536725 536930 537832 538725 540528 548588 554797 554834 557749 560292 561237 566242 580757 589238 590165 591162 593104 602061 602894 604526 607101 607152 608516 620487 623963 630913 635202 637077 638477 660365 663321 673731 674100 680030 681511 683404 683593 704184 704185 705702 709885 710266 710872 717162 719243 720889 722489 724841 732468 737910 740965 741296 742163 744607 744978 745111 759578 768692 785552 787738 789790 796629 796871 797051 803374 807847 812738 814130 822286 823030 ] |
||||||||||||||||||||||||||||||
|
16.87 ms (9.36%) |
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 709885 154491 393660 414101 823030 467110 519862 529634 538725 548588 554797 557749 663321 580757 623963 607152 602061 607101 593104 608516 637077 785552 737910 787738 759578 744978 604526 423790 429358 478773 382217 391690 396704 419600 508843 155198 396711 399038 402350 403293 411052 417825 410076 432105 814130 462802 483587 454331 468789 489347 510017 512120 499556 536930 537832 540528 560292 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 14599 396575 430380 409066 822286 468475 526453 530304 536725 529664 461755 479703 554834 561237 717162 673731 680030 681511 683404 705702 720889 722489 635202 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.38%) |
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 14599 154491 155198 382217 391690 393660 395989 396575 396704 396711 399038 402350 403293 409066 410076 411052 414101 417495 417825 419600 419998 423790 429358 430380 432105 445973 454331 458202 461738 461755 462802 465700 467110 468475 468789 478773 479703 483587 489347 496308 499556 508843 509149 510017 512120 519862 526453 529634 529664 530304 536725 536930 537832 538725 540528 548588 554797 554834 557749 560292 561237 566242 580757 589238 590165 591162 593104 602061 602894 604526 607101 607152 608516 620487 623963 630913 635202 637077 638477 660365 663321 673731 674100 680030 681511 683404 683593 704184 704185 705702 709885 710266 710872 717162 719243 720889 722489 724841 732468 737910 740965 741296 742163 744607 744978 745111 759578 768692 785552 787738 789790 796629 796871 797051 803374 807847 812738 814130 822286 823030 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl black"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк black"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк 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.