Query Metrics
7
Database Queries
7
Different statements
376.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.19 ms (55.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"double amateur"
]
|
||||||||||||||||||||||||||||||
|
145.43 ms (38.58%) |
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 97156 142735 386853 389790 401508 404112 413404 419253 471476 474289 487282 489230 490727 495516 496465 505451 514034 518642 532659 540969 542370 544746 548897 548900 550303 562588 564407 567217 571136 576512 587629 588019 591151 602966 610811 613456 622105 626464 632423 633895 636510 651310 651422 661455 663567 665927 669681 672388 677088 680588 686511 689525 689949 690012 690885 693761 701463 705119 709546 712634 717615 720138 721872 721903 725309 729216 729376 732666 733830 734098 740523 742353 746235 748895 749669 750154 750869 752785 755478 762268 764071 764220 767399 767501 768670 774650 775896 775899 775904 776994 781264 783627 784038 784066 784120 784236 788026 790761 791101 791127 795400 795549 800381 805780 808359 809562 809729 812561 814379 817240 818465 818932 818938 824421 824498 825442 826238 827484 827829 827915 ] |
||||||||||||||||||||||||||||||
|
14.20 ms (3.77%) |
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 818932 540969 548900 690012 721903 686511 690885 587629 591151 775904 790761 805780 775899 808359 791127 748895 767501 767399 613456 721872 776994 800381 487282 827915 651310 669681 610811 622105 633895 729216 632423 564407 750869 142735 97156 401508 550303 542370 680588 571136 720138 471476 474289 386853 404112 817240 514034 495516 505451 532659 548897 544746 562588 576512 661455 651422 663567 588019 795400 774650 784236 725309 740523 755478 762268 764220 781264 795549 809729 812561 742353 764071 733830 734098 775896 783627 784066 784120 413404 825442 826238 827484 818465 496465 705119 712634 689525 689949 717615 636510 750154 791101 729376 752785 768670 732666 749669 784038 809562 419253 489230 827829 518642 693761 709546 626464 788026 746235 701463 602966 567217 672388 677088 665927 389790 824498 814379 818938 824421 490727 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (0.72%) |
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 97156 142735 386853 389790 401508 404112 413404 419253 471476 474289 487282 489230 490727 495516 496465 505451 514034 518642 532659 540969 542370 544746 548897 548900 550303 562588 564407 567217 571136 576512 587629 588019 591151 602966 610811 613456 622105 626464 632423 633895 636510 651310 651422 661455 663567 665927 669681 672388 677088 680588 686511 689525 689949 690012 690885 693761 701463 705119 709546 712634 717615 720138 721872 721903 725309 729216 729376 732666 733830 734098 740523 742353 746235 748895 749669 750154 750869 752785 755478 762268 764071 764220 767399 767501 768670 774650 775896 775899 775904 776994 781264 783627 784038 784066 784120 784236 788026 790761 791101 791127 795400 795549 800381 805780 808359 809562 809729 812561 814379 817240 818465 818932 818938 824421 824498 825442 826238 827484 827829 827915 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"double любительск"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"double любительск"
]
|
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.