Query Metrics
7
Database Queries
7
Different statements
191.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.98 ms (86.23%) |
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 187960 188242 382808 388261 390898 391344 391703 392597 397889 411375 411381 424662 439658 439816 443786 460729 460901 460915 464484 465331 465365 466191 467243 467279 467484 467519 469372 471054 472000 473256 476272 476289 478024 479053 479765 481282 481929 482521 484673 488423 495224 496003 500832 502008 502932 506765 508736 509044 511594 513376 514369 514585 515841 515905 515912 518871 522445 523164 523874 528461 528512 544504 550223 555083 558001 558011 558297 559063 560430 563160 563169 563189 564655 565715 573741 573918 575177 588693 589619 589679 590540 599218 601846 614522 614628 617016 619514 620014 620097 622387 624936 634271 666446 667011 673420 706889 718524 721432 721461 721468 721482 721498 727898 728170 741702 741711 741716 741742 741770 742390 758446 781685 802132 802177 803526 807326 817293 818045 818057 826531 ] |
||||||||||||||||||||||||||||||
|
17.33 ms (9.06%) |
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 439816 528461 471054 482521 555083 558011 563169 622387 590540 614628 614522 188242 443786 460915 465365 467519 391344 411375 411381 473256 424662 465331 513376 502932 382808 388261 818057 817293 481282 563160 706889 667011 666446 721468 721482 565715 620097 634271 802177 741716 741742 741770 741702 742390 728170 619514 718524 803526 741711 818045 721461 721498 721432 617016 620014 599218 802132 758446 781685 509044 560430 439658 466191 472000 588693 460729 495224 514585 488423 467484 479053 523164 518871 573918 807326 727898 187960 467279 469372 479765 500832 502008 523874 515905 515912 508736 515841 826531 496003 550223 673420 589679 476289 528512 506765 522445 464484 392597 397889 544504 564655 558297 575177 563189 467243 390898 391703 476272 481929 514369 511594 460901 601846 484673 478024 559063 573741 558001 624936 589619 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.09%) |
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 187960 188242 382808 388261 390898 391344 391703 392597 397889 411375 411381 424662 439658 439816 443786 460729 460901 460915 464484 465331 465365 466191 467243 467279 467484 467519 469372 471054 472000 473256 476272 476289 478024 479053 479765 481282 481929 482521 484673 488423 495224 496003 500832 502008 502932 506765 508736 509044 511594 513376 514369 514585 515841 515905 515912 518871 522445 523164 523874 528461 528512 544504 550223 555083 558001 558011 558297 559063 560430 563160 563169 563189 564655 565715 573741 573918 575177 588693 589619 589679 590540 599218 601846 614522 614628 617016 619514 620014 620097 622387 624936 634271 666446 667011 673420 706889 718524 721432 721461 721468 721482 721498 727898 728170 741702 741711 741716 741742 741770 742390 758446 781685 802132 802177 803526 807326 817293 818045 818057 826531 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian mature tits"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск mature сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск mature сиськ"
]
|
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.