Query Metrics
7
Database Queries
7
Different statements
163.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.81 ms (82.04%) |
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 187595 187996 188266 359102 370957 382184 382444 385334 386189 386350 387988 389117 391156 391703 396287 397889 398244 400851 407686 407707 407768 408245 409939 409940 411409 411430 411628 411716 443925 454175 454182 454230 454559 460759 462328 463156 466136 466147 466155 466190 466229 466251 467240 467537 467550 469375 471053 471116 472703 474109 474491 475919 476363 479048 479129 481929 483374 484417 484426 484654 484696 484730 485689 485766 490407 493103 502001 506056 511522 519739 521667 522003 522627 527973 532706 532827 542206 552071 558004 563226 565625 582335 589610 592914 619223 663982 665430 693990 719903 720007 720585 721427 725138 727732 729819 741906 742385 745382 746632 748232 750159 770127 772126 776339 781995 789526 789534 793770 802157 808057 811491 816771 816776 818811 819240 819615 825114 825274 825751 826345 ] |
||||||||||||||||||||||||||||||
|
19.74 ms (12.10%) |
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 370957 387988 411716 407707 409939 409940 816776 484654 472703 469375 665430 720007 693990 721427 619223 793770 727732 741906 745382 750159 725138 720585 187595 386350 466155 467550 476363 359102 511522 519739 522003 521667 493103 391156 532706 532827 819240 819615 746632 385334 188266 382184 382444 396287 397889 398244 407686 411628 408245 816771 825114 825751 454182 471116 485689 483374 558004 563226 663982 719903 552071 565625 582335 589610 592914 776339 781995 789534 808057 789526 802157 811491 729819 748232 770127 772126 742385 386189 400851 460759 463156 471053 454230 462328 467240 407768 411409 454559 479129 389117 391703 411430 443925 466190 474491 479048 481929 466136 466147 467537 475919 502001 484417 484426 485766 527973 484730 522627 474109 490407 466251 454175 466229 506056 484696 187996 818811 826345 825274 542206 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.52%) |
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 187595 187996 188266 359102 370957 382184 382444 385334 386189 386350 387988 389117 391156 391703 396287 397889 398244 400851 407686 407707 407768 408245 409939 409940 411409 411430 411628 411716 443925 454175 454182 454230 454559 460759 462328 463156 466136 466147 466155 466190 466229 466251 467240 467537 467550 469375 471053 471116 472703 474109 474491 475919 476363 479048 479129 481929 483374 484417 484426 484654 484696 484730 485689 485766 490407 493103 502001 506056 511522 519739 521667 522003 522627 527973 532706 532827 542206 552071 558004 563226 565625 582335 589610 592914 619223 663982 665430 693990 719903 720007 720585 721427 725138 727732 729819 741906 742385 745382 746632 748232 750159 770127 772126 776339 781995 789526 789534 793770 802157 808057 811491 816771 816776 818811 819240 819615 825114 825274 825751 826345 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature big"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature большие"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature большие"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.01%) |
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.