Query Metrics
7
Database Queries
7
Different statements
356.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.04 ms (58.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step sister трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
124.51 ms (34.89%) |
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 385748 398268 419361 421956 429695 432365 432491 432526 432532 432538 432555 433218 433220 433572 433591 433742 433829 434220 434252 435437 437383 437613 441447 442402 442416 442425 443482 444279 444562 446220 448213 448295 449398 449602 451380 451838 453416 453437 455006 456811 457319 458457 459259 464152 464229 464999 465162 471761 472145 472913 473626 473636 477809 479632 483216 483952 484213 485180 490370 492136 494815 495459 496379 500420 502144 505081 505694 509384 509818 510445 511544 516128 516876 518820 521797 522121 524094 532027 542284 550635 551440 552460 557027 558863 558876 559613 559688 561338 565399 566005 566939 567716 575710 578569 580177 581721 582382 584315 584382 585323 586734 587171 599752 601364 604190 604330 604368 615438 618465 620644 621055 624661 625127 626279 662567 709431 720922 759745 779125 792651 ] |
||||||||||||||||||||||||||||||
|
15.81 ms (4.43%) |
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 453437 421956 448295 449602 473636 453416 459259 492136 524094 532027 484213 584315 709431 585323 587171 604190 615438 618465 759745 779125 792651 434220 432538 435437 432532 432526 433218 444562 473626 433742 442402 442416 472145 505694 490370 385748 559688 586734 522121 557027 542284 566939 434252 496379 483216 483952 516876 464152 561338 443482 419361 441447 510445 457319 516128 511544 558876 578569 479632 601364 458457 432555 433591 444279 505081 451380 502144 580177 518820 509818 550635 429695 446220 464999 581721 559613 552460 604330 624661 625127 621055 720922 433572 433220 433829 442425 432491 432365 437383 465162 455006 464229 472913 494815 620644 456811 509384 604368 449398 662567 626279 437613 567716 566005 398268 521797 565399 582382 451838 485180 495459 471761 558863 575710 551440 584382 599752 448213 477809 500420 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.55%) |
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 385748 398268 419361 421956 429695 432365 432491 432526 432532 432538 432555 433218 433220 433572 433591 433742 433829 434220 434252 435437 437383 437613 441447 442402 442416 442425 443482 444279 444562 446220 448213 448295 449398 449602 451380 451838 453416 453437 455006 456811 457319 458457 459259 464152 464229 464999 465162 471761 472145 472913 473626 473636 477809 479632 483216 483952 484213 485180 490370 492136 494815 495459 496379 500420 502144 505081 505694 509384 509818 510445 511544 516128 516876 518820 521797 522121 524094 532027 542284 550635 551440 552460 557027 558863 558876 559613 559688 561338 565399 566005 566939 567716 575710 578569 580177 581721 582382 584315 584382 585323 586734 587171 599752 601364 604190 604330 604368 615438 618465 620644 621055 624661 625127 626279 662567 709431 720922 759745 779125 792651 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step sister panties"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.51%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step 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.