Query Metrics
7
Database Queries
7
Different statements
192.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.71 ms (87.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 30958 61625 102043 122425 185335 285356 350700 357943 382297 383592 384325 386072 389487 389516 390908 391025 394738 397290 399595 402252 402611 402987 404053 405505 405534 405903 406237 407607 409291 415637 418922 428721 430989 434281 444007 447004 447244 447350 447548 449254 456792 458538 459231 465789 471410 475547 475859 476366 477168 484289 486309 489151 489618 497029 498544 498816 499371 499444 501732 506702 510037 511263 512593 517998 534318 535672 551299 551321 560396 564631 568081 569822 569828 573930 586662 587879 595837 598112 599433 600577 600613 601313 606809 615883 624436 625557 634755 636798 640676 640699 643405 643731 644486 660233 663375 663494 663566 664324 672485 683288 689579 696192 727394 740138 741290 744580 747372 762567 788602 790784 792591 803171 806226 813228 813478 814511 816038 817702 817734 820452 ] |
||||||||||||||||||||||||||||||
|
12.02 ms (6.26%) |
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 644486 598112 606809 727394 806226 747372 390908 560396 391025 430989 814511 499371 498544 568081 595837 599433 813228 406237 285356 405534 447350 449254 447548 511263 517998 489618 386072 394738 569828 382297 486309 664324 625557 740138 447004 501732 663494 564631 744580 383592 477168 459231 663375 672485 792591 634755 350700 409291 456792 102043 397290 476366 122425 444007 471410 415637 551299 418922 498816 600577 643731 586662 506702 61625 402611 404053 428721 816038 820452 817702 817734 689579 600613 636798 643405 813478 741290 185335 357943 402252 407607 534318 660233 587879 803171 497029 683288 573930 569822 663566 696192 601313 624436 640699 434281 512593 389487 399595 405505 458538 475859 551321 615883 790784 788602 640676 389516 402987 465789 447244 535672 510037 489151 499444 484289 762567 475547 384325 30958 405903 ] |
||||||||||||||||||||||||||||||
|
4.20 ms (2.19%) |
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 30958 61625 102043 122425 185335 285356 350700 357943 382297 383592 384325 386072 389487 389516 390908 391025 394738 397290 399595 402252 402611 402987 404053 405505 405534 405903 406237 407607 409291 415637 418922 428721 430989 434281 444007 447004 447244 447350 447548 449254 456792 458538 459231 465789 471410 475547 475859 476366 477168 484289 486309 489151 489618 497029 498544 498816 499371 499444 501732 506702 510037 511263 512593 517998 534318 535672 551299 551321 560396 564631 568081 569822 569828 573930 586662 587879 595837 598112 599433 600577 600613 601313 606809 615883 624436 625557 634755 636798 640676 640699 643405 643731 644486 660233 663375 663494 663566 664324 672485 683288 689579 696192 727394 740138 741290 744580 747372 762567 788602 790784 792591 803171 806226 813228 813478 814511 816038 817702 817734 820452 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits massage"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ массаж"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.85%) |
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.