Query Metrics
7
Database Queries
7
Different statements
265.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
242.24 ms (91.14%) |
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 384935 391934 447709 449166 454347 456690 458741 458751 459154 461525 462043 465924 467394 487079 487146 492167 495114 504644 508857 510620 511745 513274 525437 526135 526571 545979 546664 548655 552102 562208 562220 562925 567335 573853 574779 574793 574829 575132 575149 575150 575165 575470 575741 575813 576034 576041 586786 605537 611866 621779 654473 654486 654494 654499 654601 654670 654724 654794 654810 655048 655063 655085 655096 655097 655344 655395 655628 655683 655719 655724 655948 655976 656027 656042 656048 656064 656354 656418 656680 656782 656783 656963 657050 657074 657279 657346 657411 657422 657705 657723 658285 658349 658359 658583 658670 658698 659113 659140 659155 659557 659565 659638 659650 659739 659759 660499 660525 660535 660970 669344 704887 718543 721294 724586 726022 729586 734696 805788 813426 ] |
||||||||||||||||||||||||||||||
|
13.46 ms (5.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 526135 526571 508857 513274 525437 654794 656418 449166 548655 447709 545979 657074 654473 654837 659565 659557 654601 576034 655628 562208 574793 391934 574829 575149 655344 657050 658359 660525 654486 654499 654670 655724 655976 656680 657346 657411 660970 655948 656963 657705 657723 658670 704887 573853 611866 734696 458741 456690 465924 660535 655063 654810 656064 458751 656782 655097 459154 562220 567335 575813 504644 511745 384935 552102 562925 656042 658698 659113 659155 659638 659739 655085 656048 658285 659759 660499 669344 721294 655683 658583 659140 659650 605537 729586 805788 724586 726022 718543 813426 461525 454347 655719 655096 510620 654724 655048 655395 656027 658349 462043 575741 575150 575165 575470 576041 621779 487146 495114 586786 487079 575132 492167 546664 657279 654494 656354 656783 657422 467394 574779 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.05%) |
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 384935 391934 447709 449166 454347 456690 458741 458751 459154 461525 462043 465924 467394 487079 487146 492167 495114 504644 508857 510620 511745 513274 525437 526135 526571 545979 546664 548655 552102 562208 562220 562925 567335 573853 574779 574793 574829 575132 575149 575150 575165 575470 575741 575813 576034 576041 586786 605537 611866 621779 654473 654486 654494 654499 654601 654670 654724 654794 654810 655048 655063 655085 655096 655097 655344 655395 655628 655683 655719 655724 655948 655976 656027 656042 656048 656064 656354 656418 656680 656782 656783 656963 657050 657074 657279 657346 657411 657422 657705 657723 658285 658349 658359 658583 658670 658698 659113 659140 659155 659557 659565 659638 659650 659739 659759 660499 660525 660535 660970 669344 704887 718543 721294 724586 726022 729586 734696 805788 813426 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian cuckold sex"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск куколд секс"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.63%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.