Query Metrics
7
Database Queries
7
Different statements
166.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.77 ms (84.90%) |
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 4463 13118 15162 16946 285923 307310 382071 384423 385086 385633 385854 387562 391121 395664 395703 395860 395919 396687 397265 397505 398073 398689 399585 400459 401591 402217 403289 404696 411443 411539 413071 413135 413282 414070 416511 416982 418357 418363 418770 419128 420147 420760 421414 421573 423299 425117 426336 426348 426360 429877 431439 436849 442632 443103 443333 446531 446856 447659 453788 456069 457889 461402 462681 463968 464179 464180 468718 471375 473091 473240 476143 476176 476259 479266 479694 481904 485049 485363 485994 489561 491271 493033 498454 498560 498910 500732 503152 503310 511816 512938 514073 514392 517844 519085 523970 531120 531235 533948 534702 544665 551164 556316 559294 560650 565956 571219 574924 596168 597018 600159 605122 668512 683826 715191 717800 721744 741157 790875 795538 801287 ] |
||||||||||||||||||||||||||||||
|
15.22 ms (9.12%) |
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 560650 476176 479694 446531 473091 498910 519085 523970 534702 503310 416982 511816 391121 418770 413135 418357 471375 461402 559294 683826 571219 600159 795538 790875 4463 436849 479266 395703 397265 387562 397505 401591 411443 385854 491271 485363 485994 395664 307310 442632 423299 462681 453788 556316 721744 16946 402217 414070 476143 446856 456069 503152 426336 419128 457889 493033 498560 533948 468718 512938 385086 285923 715191 668512 597018 741157 385633 396687 398073 413282 382071 544665 574924 420760 443103 481904 531120 531235 421573 464179 517844 605122 418363 425117 596168 500732 485049 399585 431439 447659 464180 514073 717800 15162 395860 398689 429877 384423 403289 404696 411539 426360 13118 413071 426348 489561 476259 551164 801287 400459 416511 420147 473240 395919 443333 565956 463968 421414 514392 498454 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.61%) |
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 4463 13118 15162 16946 285923 307310 382071 384423 385086 385633 385854 387562 391121 395664 395703 395860 395919 396687 397265 397505 398073 398689 399585 400459 401591 402217 403289 404696 411443 411539 413071 413135 413282 414070 416511 416982 418357 418363 418770 419128 420147 420760 421414 421573 423299 425117 426336 426348 426360 429877 431439 436849 442632 443103 443333 446531 446856 447659 453788 456069 457889 461402 462681 463968 464179 464180 468718 471375 473091 473240 476143 476176 476259 479266 479694 481904 485049 485363 485994 489561 491271 493033 498454 498560 498910 500732 503152 503310 511816 512938 514073 514392 517844 519085 523970 531120 531235 533948 534702 544665 551164 556316 559294 560650 565956 571219 574924 596168 597018 600159 605122 668512 683826 715191 717800 721744 741157 790875 795538 801287 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful blonde anal"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая беловолосая анал"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.94%) |
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.