Query Metrics
7
Database Queries
7
Different statements
187.64 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.72 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.81 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife with black"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.78 ms |
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 543234 668688 675515 606377 610060 585999 587272 604387 458986 444703 463716 419358 517204 483094 524859 518587 533529 542627 716969 651003 651276 788562 464194 456109 519105 462610 808077 419483 419989 606541 419862 421967 440632 468592 514847 529405 534791 521810 554441 675123 609784 612061 395503 452363 439723 494269 456955 505797 593279 385784 480417 471859 399355 421250 425356 524865 582376 592728 605398 399300 446976 452242 535013 518438 426405 445733 586534 508856 506612 545802 607230 417829 582035 603623 478527 517652 391386 451983 627750 554392 478672 417328 603907 522478 530291 577108 584708 ] |
||||||||||||||||||||||||||||||
| 4 | 3.28 ms |
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 385784 391386 395503 399300 399355 417328 417829 419358 419483 419862 419989 421250 421967 425356 426405 439723 440632 444703 445733 446976 451983 452242 452363 456109 456955 458986 462610 463716 464194 468592 471859 478527 478672 480417 483094 494269 505797 506612 508856 514847 517204 517652 518438 518587 519105 521810 522478 524859 524865 529405 530291 533529 534791 535013 542627 543234 545802 554392 554441 577108 582035 582376 584708 585999 586534 587272 592728 593279 603623 603907 604387 605398 606377 606541 607230 609784 610060 612061 627750 651003 651276 668688 675123 675515 716969 788562 808077 ] |
||||||||||||||||||||||||||||||
| 5 | 161.77 ms |
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 385784 391386 395503 399300 399355 417328 417829 419358 419483 419862 419989 421250 421967 425356 426405 439723 440632 444703 445733 446976 451983 452242 452363 456109 456955 458986 462610 463716 464194 468592 471859 478527 478672 480417 483094 494269 505797 506612 508856 514847 517204 517652 518438 518587 519105 521810 522478 524859 524865 529405 530291 533529 534791 535013 542627 543234 545802 554392 554441 577108 582035 582376 584708 585999 586534 587272 592728 593279 603623 603907 604387 605398 606377 606541 607230 609784 610060 612061 627750 651003 651276 668688 675123 675515 716969 788562 808077 ] |
||||||||||||||||||||||||||||||
| 6 | 1.73 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен black"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.56 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен black"
]
|
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.