Query Metrics
7
Database Queries
7
Different statements
203.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.83 ms (87.43%) |
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 47707 89895 191485 386166 389959 394597 397553 400642 415112 416652 416677 416751 418009 418068 421037 423650 427174 429286 429906 432779 433212 433318 440629 447692 448630 448805 448862 452773 453203 453948 453973 457943 460086 465590 468610 469700 473831 480024 483220 486946 489931 495401 497485 500748 502770 510781 514241 518497 520400 521426 528034 529011 531249 532381 533384 545822 545838 549079 549099 552623 563969 568457 574166 575286 576895 586102 586597 586598 594049 597482 603057 606721 607091 612436 618398 618483 620115 620198 622645 629326 629619 644430 644453 651601 651957 652179 652939 654279 654919 664459 670040 674713 674863 675866 692455 693952 694010 696594 710286 710946 720095 720815 723287 735768 737360 740409 752650 772684 776154 777173 784256 786879 791321 799762 799975 805069 805164 819557 821829 826182 ] |
||||||||||||||||||||||||||||||
|
15.05 ms (7.40%) |
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 429906 480024 586597 423650 514241 586598 552623 651601 457943 469700 502770 574166 710286 549099 594049 776154 772684 799975 432779 421037 489931 500748 416677 416751 452773 568457 416652 510781 533384 532381 545838 575286 549079 674713 694010 696594 710946 606721 629619 612436 786879 740409 497485 651957 652939 720815 603057 805164 737360 735768 644453 777173 784256 483220 433212 418009 473831 495401 433318 427174 429286 821829 652179 618398 597482 620115 752650 448630 397553 486946 520400 448805 453203 576895 521426 620198 415112 418068 518497 545822 791321 400642 191485 654279 622645 607091 629326 47707 465590 692455 586102 618483 805069 386166 389959 440629 826182 529011 528034 563969 693952 654919 720095 799762 644430 89895 453973 819557 468610 531249 460086 670040 664459 723287 394597 447692 448862 453948 675866 674863 ] |
||||||||||||||||||||||||||||||
|
3.66 ms (1.80%) |
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 47707 89895 191485 386166 389959 394597 397553 400642 415112 416652 416677 416751 418009 418068 421037 423650 427174 429286 429906 432779 433212 433318 440629 447692 448630 448805 448862 452773 453203 453948 453973 457943 460086 465590 468610 469700 473831 480024 483220 486946 489931 495401 497485 500748 502770 510781 514241 518497 520400 521426 528034 529011 531249 532381 533384 545822 545838 549079 549099 552623 563969 568457 574166 575286 576895 586102 586597 586598 594049 597482 603057 606721 607091 612436 618398 618483 620115 620198 622645 629326 629619 644430 644453 651601 651957 652179 652939 654279 654919 664459 670040 674713 674863 675866 692455 693952 694010 696594 710286 710946 720095 720815 723287 735768 737360 740409 752650 772684 776154 777173 784256 786879 791321 799762 799975 805069 805164 819557 821829 826182 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen fuck compilation"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen секс подборк"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.79%) |
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.