Query Metrics
7
Database Queries
7
Different statements
144.78 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.81 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.00 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"perfect body girl"
]
|
||||||||||||||||||||||||||||||
| 3 | 19.18 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 566247 780760 709082 452554 476510 477235 513848 495985 533131 691335 567272 589972 474383 502195 451854 513872 427553 540032 626597 589968 596412 601200 709128 470856 514966 456837 578116 582889 655582 589900 435968 515554 514982 525439 545292 589957 621055 495769 514955 567331 446560 581662 514999 467744 594422 524297 514977 512844 520244 525474 426357 456839 624909 418607 452593 516051 559837 510321 448260 523035 548849 607694 587946 465745 527602 471818 589105 498402 569260 571228 480197 605418 452286 398877 498014 629045 624390 604051 545300 553272 652572 529070 571834 504718 616024 ] |
||||||||||||||||||||||||||||||
| 4 | 2.63 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 398877 418607 426357 427553 435968 446560 448260 451854 452286 452554 452593 456837 456839 465745 467744 470856 471818 474383 476510 477235 480197 495769 495985 498014 498402 502195 504718 510321 512844 513848 513872 514955 514966 514977 514982 514999 515554 516051 520244 523035 524297 525439 525474 527602 529070 533131 540032 545292 545300 548849 553272 559837 566247 567272 567331 569260 571228 571834 578116 581662 582889 587946 589105 589900 589957 589968 589972 594422 596412 601200 604051 605418 607694 616024 621055 624390 624909 626597 629045 652572 655582 691335 709082 709128 780760 ] |
||||||||||||||||||||||||||||||
| 5 | 116.22 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 398877 418607 426357 427553 435968 446560 448260 451854 452286 452554 452593 456837 456839 465745 467744 470856 471818 474383 476510 477235 480197 495769 495985 498014 498402 502195 504718 510321 512844 513848 513872 514955 514966 514977 514982 514999 515554 516051 520244 523035 524297 525439 525474 527602 529070 533131 540032 545292 545300 548849 553272 559837 566247 567272 567331 569260 571228 571834 578116 581662 582889 587946 589105 589900 589957 589968 589972 594422 596412 601200 604051 605418 607694 616024 621055 624390 624909 626597 629045 652572 655582 691335 709082 709128 780760 ] |
||||||||||||||||||||||||||||||
| 6 | 1.57 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"perfect body девушк"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.37 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"perfect body девушк"
]
|
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.