Query Metrics
7
Database Queries
7
Different statements
161.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.92 ms (82.92%) |
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 386727 398681 400697 417934 418066 420606 424560 425537 427355 427702 428154 429288 432372 433058 433571 433940 437156 439521 439523 442451 443439 444131 444391 444916 444994 446920 447638 448901 449700 449738 450700 453195 455470 455562 456274 456684 456876 457059 457630 458219 465757 466184 466240 467620 467750 468878 469629 470599 471024 472138 472849 473858 475568 482845 482870 483275 483321 483838 483997 484332 484992 485499 487460 489226 490015 490400 490652 492395 494834 495282 495522 496375 500397 503088 503635 504779 504875 506106 509083 513004 513390 514011 514042 516295 516873 517189 517912 518023 518336 519237 520085 520109 520523 520905 521793 522242 522990 523457 523933 525327 527164 528552 535589 535918 537963 540268 560800 567593 571029 576706 586146 590499 593366 603675 629688 740497 785055 787728 812741 813245 ] |
||||||||||||||||||||||||||||||
|
17.90 ms (11.09%) |
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 418066 427355 433571 437156 443439 471024 398681 400697 420606 427702 428154 429288 433940 446920 447638 456274 467620 467750 475568 424560 449700 449738 450700 453195 455562 456876 458219 466184 468878 469629 470599 500397 504875 513390 517912 520085 520109 520523 522990 523933 537963 483838 485499 490400 490652 513004 516873 517189 518023 520905 483275 483997 484332 489226 495282 496375 503088 516295 519237 522242 540268 484992 494834 503635 509083 514011 521793 525327 629688 386727 593366 504779 535918 590499 586146 787728 812741 740497 785055 813245 442451 433058 448901 506106 523457 473858 417934 457059 432372 455470 482870 487460 528552 576706 444391 535589 444916 490015 571029 567593 444994 444131 425537 457630 465757 514042 527164 482845 472849 495522 560800 439521 466240 439523 456684 472138 518336 483321 492395 603675 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.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 386727 398681 400697 417934 418066 420606 424560 425537 427355 427702 428154 429288 432372 433058 433571 433940 437156 439521 439523 442451 443439 444131 444391 444916 444994 446920 447638 448901 449700 449738 450700 453195 455470 455562 456274 456684 456876 457059 457630 458219 465757 466184 466240 467620 467750 468878 469629 470599 471024 472138 472849 473858 475568 482845 482870 483275 483321 483838 483997 484332 484992 485499 487460 489226 490015 490400 490652 492395 494834 495282 495522 496375 500397 503088 503635 504779 504875 506106 509083 513004 513390 514011 514042 516295 516873 517189 517912 518023 518336 519237 520085 520109 520523 520905 521793 522242 522990 523457 523933 525327 527164 528552 535589 535918 537963 540268 560800 567593 571029 576706 586146 590499 593366 603675 629688 740497 785055 787728 812741 813245 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"nurse panties bra"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"врачих трусик нижн бел бюстгалтер нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"врачих трусик нижн бел бюстгалтер нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.