Query Metrics
7
Database Queries
7
Different statements
417.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.47 ms (51.67%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бюстгалтер нижн бел white"
]
|
||||||||||||||||||||||||||||||
|
174.24 ms (41.78%) |
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 4279 200708 388887 397601 423815 424567 424986 427702 427776 428154 431471 433940 437156 437294 437669 441877 444095 447638 450330 450587 451088 453195 453476 455516 456462 456876 457002 458219 458873 459308 460092 460872 461224 462258 463581 464246 465116 465173 465958 466588 467620 467690 467959 468278 468878 469629 469728 469831 470599 472040 472525 475693 476557 476792 477243 477695 479253 479271 480430 480986 481352 481568 481573 482973 483275 483838 483997 484226 485062 485499 486133 487479 488684 489226 489556 490218 490652 494905 495282 499969 501264 502281 503088 503635 504875 508783 509391 511518 511772 512019 512487 513004 513390 513725 514011 516295 517189 517859 517912 518023 518041 518405 518548 519237 520085 520109 520817 521793 522011 522242 522990 523933 524684 525327 525565 525713 526396 527022 537963 540268 ] |
||||||||||||||||||||||||||||||
|
19.71 ms (4.73%) |
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 486133 480986 444095 397601 200708 480430 525713 424986 437669 441877 467959 469728 488684 489556 451088 453476 459308 461224 465173 469831 477243 481352 450330 455516 465116 466588 472525 475693 494905 501264 502281 460092 472040 482973 487479 427776 458873 465958 468278 479271 481568 437156 423815 427702 428154 433940 447638 467620 453195 456876 458219 468878 469629 470599 504875 513390 517912 520085 520109 522990 523933 527022 537963 483838 485499 490652 512487 513004 517189 518023 483275 483997 489226 495282 503088 516295 519237 522242 540268 503635 508783 514011 521793 525327 456462 490218 476557 476792 424567 522011 511518 512019 485062 517859 520817 4279 388887 431471 460872 462258 457002 477695 509391 511772 518405 464246 467690 463581 479253 437294 481573 450587 499969 513725 518548 526396 484226 518041 524684 525565 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (0.67%) |
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 4279 200708 388887 397601 423815 424567 424986 427702 427776 428154 431471 433940 437156 437294 437669 441877 444095 447638 450330 450587 451088 453195 453476 455516 456462 456876 457002 458219 458873 459308 460092 460872 461224 462258 463581 464246 465116 465173 465958 466588 467620 467690 467959 468278 468878 469629 469728 469831 470599 472040 472525 475693 476557 476792 477243 477695 479253 479271 480430 480986 481352 481568 481573 482973 483275 483838 483997 484226 485062 485499 486133 487479 488684 489226 489556 490218 490652 494905 495282 499969 501264 502281 503088 503635 504875 508783 509391 511518 511772 512019 512487 513004 513390 513725 514011 516295 517189 517859 517912 518023 518041 518405 518548 519237 520085 520109 520817 521793 522011 522242 522990 523933 524684 525327 525565 525713 526396 527022 537963 540268 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bra white"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.38%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бюстгалтер нижн бел white"
]
|
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.