Query Metrics
7
Database Queries
7
Different statements
163.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.35 ms (86.09%) |
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 322090 341691 383763 396206 398623 401319 401979 403285 403289 405472 412208 413393 414783 417721 417745 428470 447644 447661 451683 456094 459832 462787 463905 466604 468712 475317 484464 527487 527488 527526 527530 527531 527548 527552 527580 528901 528962 528965 528987 528999 529020 529026 529034 529036 529037 529040 529050 529058 529061 529063 529068 529069 529854 530756 533747 536674 539938 561659 565272 571215 571219 575727 584287 594469 595538 596255 596290 597241 598056 598135 598478 600146 603432 603464 605322 605323 605324 605325 605326 605328 605330 605331 605332 605333 605334 605335 605342 609878 619375 622394 624785 638540 644311 644330 655811 663176 665727 671099 671101 671102 671814 702624 713139 714526 718084 719926 720009 720697 727669 729815 729894 730674 735990 737734 740344 774121 774469 800224 811166 811210 ] |
||||||||||||||||||||||||||||||
|
13.46 ms (8.26%) |
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 671099 774469 740344 536674 565272 720009 718084 529061 529068 671101 737734 527487 596290 584287 603464 414783 529037 528999 800224 774121 714526 603432 605331 605334 605333 713139 529854 539938 383763 671814 595538 729815 529040 527531 456094 451683 605324 605322 605328 605330 644311 462787 412208 528962 528987 527488 663176 655811 594469 811210 401319 398623 403285 463905 484464 529026 727669 730674 322090 529050 459832 447661 466604 417721 671102 529069 622394 447644 598056 605335 529034 533747 428470 413393 475317 527548 529020 527526 527580 605332 811166 396206 528965 529063 598478 527552 624785 735990 341691 527530 596255 597241 605326 719926 529058 530756 417745 605323 638540 561659 665727 720697 600146 598135 401979 405472 468712 528901 575727 571215 571219 609878 605325 605342 729894 619375 644330 702624 403289 529036 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.44%) |
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 322090 341691 383763 396206 398623 401319 401979 403285 403289 405472 412208 413393 414783 417721 417745 428470 447644 447661 451683 456094 459832 462787 463905 466604 468712 475317 484464 527487 527488 527526 527530 527531 527548 527552 527580 528901 528962 528965 528987 528999 529020 529026 529034 529036 529037 529040 529050 529058 529061 529063 529068 529069 529854 530756 533747 536674 539938 561659 565272 571215 571219 575727 584287 594469 595538 596255 596290 597241 598056 598135 598478 600146 603432 603464 605322 605323 605324 605325 605326 605328 605330 605331 605332 605333 605334 605335 605342 609878 619375 622394 624785 638540 644311 644330 655811 663176 665727 671099 671101 671102 671814 702624 713139 714526 718084 719926 720009 720697 727669 729815 729894 730674 735990 737734 740344 774121 774469 800224 811166 811210 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny teen casting"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые teen кастинг"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые teen кастинг"
]
|
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.