Query Metrics
7
Database Queries
7
Different statements
187.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.50 ms (84.92%) |
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 33309 383985 386638 389218 390382 390569 391076 391582 391703 391955 400845 400862 405074 407768 408313 411121 411338 413520 421781 422353 422358 423641 424435 425993 426518 428150 430297 432872 443405 451523 454110 454192 455008 459347 459946 462101 462324 462690 465343 466014 466913 468199 468647 469453 470309 473472 473891 474079 477714 479989 480903 485679 485684 485732 485768 487340 488118 496548 497497 502279 512687 514878 514906 515076 515925 515986 518006 518957 522191 524860 527131 527144 529315 529390 540727 542247 549697 549698 549706 554880 556620 563146 568053 570958 583572 589192 593344 595783 597477 599525 601342 604955 614365 626885 724412 728194 735910 741726 741779 742414 744987 748238 748463 751513 757110 760859 770102 794240 794247 794795 795483 797525 798948 807980 808155 809272 812367 819701 825039 827473 ] |
||||||||||||||||||||||||||||||
|
18.13 ms (9.65%) |
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 614365 390569 443405 425993 413520 827473 459347 474079 485684 515925 497497 514878 512687 540727 487340 549697 599525 593344 601342 794247 798948 748238 748463 757110 797525 741726 744987 724412 735910 391955 424435 432872 400862 383985 411338 454110 477714 386638 391076 407768 391703 428150 480903 485679 488118 527131 390382 400845 422358 466014 514906 529315 515986 518006 563146 549706 589192 809272 728194 466913 454192 473891 430297 451523 405074 455008 794240 795483 742414 770102 741779 751513 794795 391582 473472 469453 568053 812367 459946 468199 485732 515076 527144 542247 570958 583572 597477 808155 807980 760859 556620 462324 422353 496548 595783 524860 522191 462101 518957 502279 554880 470309 626885 479989 549698 604955 529390 421781 33309 389218 408313 411121 426518 423641 819701 825039 462690 465343 468647 485768 ] |
||||||||||||||||||||||||||||||
|
2.86 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 33309 383985 386638 389218 390382 390569 391076 391582 391703 391955 400845 400862 405074 407768 408313 411121 411338 413520 421781 422353 422358 423641 424435 425993 426518 428150 430297 432872 443405 451523 454110 454192 455008 459347 459946 462101 462324 462690 465343 466014 466913 468199 468647 469453 470309 473472 473891 474079 477714 479989 480903 485679 485684 485732 485768 487340 488118 496548 497497 502279 512687 514878 514906 515076 515925 515986 518006 518957 522191 524860 527131 527144 529315 529390 540727 542247 549697 549698 549706 554880 556620 563146 568053 570958 583572 589192 593344 595783 597477 599525 601342 604955 614365 626885 724412 728194 735910 741726 741779 742414 744987 748238 748463 751513 757110 760859 770102 794240 794247 794795 795483 797525 798948 807980 808155 809272 812367 819701 825039 827473 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"толстушки в чулках кончают"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"полная чулк нижн бел сперм"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.85%) |
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.