Query Metrics
7
Database Queries
7
Different statements
203.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.68 ms (80.98%) |
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 12169 12731 388007 420587 428103 430416 431730 433319 433498 434209 434601 434933 437663 447454 451552 452137 454241 454554 454765 456705 457423 457590 463825 464418 466180 466801 469200 469434 471997 472317 472544 472645 478828 479989 482559 484369 485100 486589 488330 489325 489328 489448 490953 491248 493197 494500 495212 495302 497235 497492 502868 503105 504121 504908 511011 512955 514721 517740 519653 520171 522779 523979 525149 526170 527443 527664 531603 533544 536637 541095 541467 549331 551137 554498 567777 569041 570159 585112 585717 587904 591817 592318 602928 603117 609909 618761 622200 632137 632676 635249 643122 644005 644363 650375 650796 654208 660274 662601 670036 677714 697774 720450 721954 739595 745655 745966 748214 750223 750334 758077 758842 772107 774009 792938 797624 799020 805201 808500 814347 816007 ] |
||||||||||||||||||||||||||||||
|
27.10 ms (13.32%) |
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 457590 434933 447454 478828 522779 527443 484369 514721 526170 502868 488330 494500 520171 527664 420587 454554 466801 511011 512955 517740 519653 650796 774009 454765 454241 495212 12169 434209 464418 489448 523979 549331 677714 654208 660274 670036 603117 622200 758842 772107 748214 745966 750223 632137 697774 721954 792938 434601 551137 485100 486589 602928 431730 541095 504908 428103 433319 489328 433498 814347 456705 472645 463825 479989 482559 491248 504121 503105 472544 567777 569041 644005 585717 466180 469200 457423 489325 541467 490953 388007 585112 452137 471997 497235 533544 525149 531603 554498 720450 650375 632676 591817 609909 618761 805201 739595 758077 799020 745655 750334 644363 797624 808500 12731 430416 437663 816007 469434 472317 493197 497492 495302 536637 570159 662601 635249 587904 592318 643122 451552 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (1.62%) |
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 12169 12731 388007 420587 428103 430416 431730 433319 433498 434209 434601 434933 437663 447454 451552 452137 454241 454554 454765 456705 457423 457590 463825 464418 466180 466801 469200 469434 471997 472317 472544 472645 478828 479989 482559 484369 485100 486589 488330 489325 489328 489448 490953 491248 493197 494500 495212 495302 497235 497492 502868 503105 504121 504908 511011 512955 514721 517740 519653 520171 522779 523979 525149 526170 527443 527664 531603 533544 536637 541095 541467 549331 551137 554498 567777 569041 570159 585112 585717 587904 591817 592318 602928 603117 609909 618761 622200 632137 632676 635249 643122 644005 644363 650375 650796 654208 660274 662601 670036 677714 697774 720450 721954 739595 745655 745966 748214 750223 750334 758077 758842 772107 774009 792938 797624 799020 805201 808500 814347 816007 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.36%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"licking compilation"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза подборк"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.84%) |
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.