Query Metrics
7
Database Queries
7
Different statements
182.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.76 ms (84.65%) |
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 182206 209216 388133 391950 392676 409454 418102 420219 427364 429884 429892 429899 429902 434309 434318 434332 434334 434344 434345 434374 435562 441041 441046 444322 445825 448140 450274 452968 453409 454725 457292 457294 457998 458673 460465 462226 462840 464978 466814 467877 467878 467908 469393 469432 471022 471035 472665 472835 476191 486244 493717 498226 499388 502559 506674 508378 516574 520992 523381 525204 534553 541482 541487 547241 554526 555565 560409 566863 574049 574657 583866 584009 587235 596796 596935 597091 600492 602056 604059 604423 607717 611238 613615 621298 623606 623610 634071 652507 702125 707757 710590 713332 714335 722373 738477 743634 744197 751432 752653 752663 760686 761289 770269 773926 784648 786610 787336 787867 797068 799042 803492 803824 804159 804427 806427 807422 808068 810409 812229 817271 ] |
||||||||||||||||||||||||||||||
|
17.55 ms (9.60%) |
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 738477 752663 784648 804159 634071 388133 467878 498226 448140 450274 469393 534553 574657 604423 607717 621298 604059 623610 434334 458673 525204 392676 506674 476191 457292 462840 452968 467908 471035 429884 441046 817271 486244 710590 707757 613615 596796 596935 600492 797068 803824 807422 810409 812229 773926 808068 760686 770269 751432 602056 611238 623606 713332 786610 787867 799042 806427 434332 409454 434344 391950 441041 209216 429892 560409 466814 520992 541487 457998 467877 464978 493717 471022 744197 554526 722373 453409 418102 454725 597091 547241 457294 434374 469432 472665 587235 420219 434345 445825 462226 523381 460465 541482 583866 574049 584009 714335 652507 702125 566863 804427 803492 761289 752653 743634 787336 429902 434318 472835 508378 516574 182206 555565 434309 444322 427364 435562 499388 502559 429899 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.56%) |
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 182206 209216 388133 391950 392676 409454 418102 420219 427364 429884 429892 429899 429902 434309 434318 434332 434334 434344 434345 434374 435562 441041 441046 444322 445825 448140 450274 452968 453409 454725 457292 457294 457998 458673 460465 462226 462840 464978 466814 467877 467878 467908 469393 469432 471022 471035 472665 472835 476191 486244 493717 498226 499388 502559 506674 508378 516574 520992 523381 525204 534553 541482 541487 547241 554526 555565 560409 566863 574049 574657 583866 584009 587235 596796 596935 597091 600492 602056 604059 604423 607717 611238 613615 621298 623606 623610 634071 652507 702125 707757 710590 713332 714335 722373 738477 743634 744197 751432 752653 752663 760686 761289 770269 773926 784648 786610 787336 787867 797068 799042 803492 803824 804159 804427 806427 807422 808068 810409 812229 817271 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo dildo hairy"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло дилд волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло дилд волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.99%) |
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.