Query Metrics
7
Database Queries
7
Different statements
240.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.06 ms (86.88%) |
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 241603 287436 384757 414339 416824 425143 439532 444684 446529 450518 463855 465334 473428 474874 476417 478775 479768 479845 485468 489305 499856 511372 514254 518183 518419 519234 521677 521850 522043 522142 530791 530796 530941 532345 536310 537250 541832 541851 542583 547235 550203 552701 556476 561909 572784 582526 590263 590507 590696 590908 592500 596226 601691 607560 610083 613637 618256 621125 622066 629630 632794 633163 633521 633768 636303 639762 642038 645230 647322 648583 650175 651161 666470 671083 674077 675019 676097 677801 677986 678063 678128 678144 678161 678533 679728 695893 696154 699718 704526 708443 716900 716965 717924 721106 721992 723930 728072 745126 745384 748257 749070 752664 752676 755437 761432 770213 770253 787466 788567 799268 802114 806271 811125 813063 814270 816547 816669 818387 819565 821409 ] |
||||||||||||||||||||||||||||||
|
20.67 ms (8.59%) |
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 550203 542583 650175 678144 678161 679728 677801 677986 678533 704526 647322 675019 639762 636303 610083 633521 633768 642038 708443 463855 478775 474874 476417 590908 287436 816669 489305 473428 519234 601691 416824 541832 674077 633163 537250 541851 648583 552701 590507 596226 632794 590263 629630 439532 511372 446529 530796 521850 532345 530791 530941 536310 678063 676097 678128 716900 425143 479768 522043 522142 745384 622066 787466 621125 241603 444684 814270 818387 819565 821409 816547 485468 450518 499856 514254 547235 572784 556476 582526 561909 666470 695893 645230 671083 696154 721106 721992 651161 699718 717924 592500 590696 613637 806271 752676 788567 799268 811125 770213 723930 745126 749070 755437 728072 748257 761432 770253 752664 607560 618256 716965 802114 813063 465334 479845 518419 521677 518183 384757 414339 ] |
||||||||||||||||||||||||||||||
|
4.11 ms (1.71%) |
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 241603 287436 384757 414339 416824 425143 439532 444684 446529 450518 463855 465334 473428 474874 476417 478775 479768 479845 485468 489305 499856 511372 514254 518183 518419 519234 521677 521850 522043 522142 530791 530796 530941 532345 536310 537250 541832 541851 542583 547235 550203 552701 556476 561909 572784 582526 590263 590507 590696 590908 592500 596226 601691 607560 610083 613637 618256 621125 622066 629630 632794 633163 633521 633768 636303 639762 642038 645230 647322 648583 650175 651161 666470 671083 674077 675019 676097 677801 677986 678063 678128 678144 678161 678533 679728 695893 696154 699718 704526 708443 716900 716965 717924 721106 721992 723930 728072 745126 745384 748257 749070 752664 752676 755437 761432 770213 770253 787466 788567 799268 802114 806271 811125 813063 814270 816547 816669 818387 819565 821409 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dick and dildo"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.69%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"член дилд"
]
|
||||||||||||||||||||||||||||||
|
1.23 ms (0.51%) |
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.