Query Metrics
7
Database Queries
7
Different statements
164.38 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.66 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.73 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sister tits jerking"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.94 ms |
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 492135 100665 420830 420329 495557 453732 542860 483039 489653 522653 555930 624661 599150 625088 424917 438906 447783 518056 489712 591309 419292 465084 559949 567716 495554 473636 621120 519275 454872 528867 602603 625140 434931 511369 471761 561481 561338 500420 417099 500226 511413 581291 561183 602504 618465 438852 511555 519392 463215 497951 445551 560489 526805 526811 447163 456925 521768 493242 623615 456888 528766 449855 457186 508549 429695 501015 574679 446659 515868 559757 601364 524257 505526 557027 584197 441929 432510 599326 672328 599725 426919 497413 503110 522318 621735 505794 628277 428480 618743 521815 ] |
||||||||||||||||||||||||||||||
| 4 | 3.74 ms |
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 100665 417099 419292 420329 420830 424917 426919 428480 429695 432510 434931 438852 438906 441929 445551 446659 447163 447783 449855 453732 454872 456888 456925 457186 463215 465084 471761 473636 483039 489653 489712 492135 493242 495554 495557 497413 497951 500226 500420 501015 503110 505526 508549 511369 511413 511555 515868 518056 519275 519392 521768 521815 522318 522653 524257 526805 526811 528766 528867 542860 555930 557027 559757 559949 560489 561183 561338 561481 567716 574679 581291 584197 591309 599150 599326 599725 601364 602504 602603 618465 618743 621120 621735 623615 624661 625088 625140 628277 672328 ] |
||||||||||||||||||||||||||||||
| 5 | 137.21 ms |
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 100665 417099 419292 420329 420830 424917 426919 428480 429695 432510 434931 438852 438906 441929 445551 446659 447163 447783 449855 453732 454872 456888 456925 457186 463215 465084 471761 473636 483039 489653 489712 492135 493242 495554 495557 497413 497951 500226 500420 501015 503110 505526 508549 511369 511413 511555 515868 518056 519275 519392 521768 521815 522318 522653 524257 526805 526811 528766 528867 542860 555930 557027 559757 559949 560489 561183 561338 561481 567716 574679 581291 584197 591309 599150 599326 599725 601364 602504 602603 618465 618743 621120 621735 623615 624661 625088 625140 628277 672328 ] |
||||||||||||||||||||||||||||||
| 6 | 1.51 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sister сиськ дрочк"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.58 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sister сиськ дрочк"
]
|
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.