Query Metrics
7
Database Queries
7
Different statements
180.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.61 ms (83.98%) |
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 185494 255858 384156 385475 392597 398440 400692 409933 424567 427857 429211 429301 429594 429723 432196 433855 433885 434230 435398 439445 442086 443202 448072 448885 452728 453434 454631 454852 455185 456258 456315 458726 459022 460009 460406 461420 461962 462020 463922 464724 467907 468869 469104 472085 474430 475703 476206 476557 476792 477797 479527 479810 480046 480096 483022 483878 485062 487775 487891 488259 490172 492398 492758 492798 494242 496492 496520 498078 500067 507517 509518 509614 509699 509780 510330 511518 511868 512019 512733 514731 515465 515507 517859 517908 518809 519229 519397 519530 520817 521055 521396 521803 522011 522551 524075 524570 524657 526621 528276 529072 538228 545667 555786 559222 595711 603286 695796 702136 706465 716203 716230 738325 758553 767478 769339 784693 787702 792390 828445 828770 ] |
||||||||||||||||||||||||||||||
|
17.87 ms (9.90%) |
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 185494 385475 432196 452728 460009 462020 480046 480096 427857 429211 429301 433855 433885 434230 448885 455185 456315 460406 461962 463922 474430 454631 472085 509614 510330 514731 515465 518809 528276 529072 492398 496520 498078 509518 509699 511868 515507 521396 522551 483878 492798 519229 524657 487775 487891 494242 496492 509780 519397 521055 521803 538228 716230 695796 787702 477797 555786 476557 392597 435398 476792 424567 522011 511518 512019 485062 517859 520817 716203 738325 469104 476206 603286 519530 524075 409933 512733 507517 559222 384156 702136 828445 448072 517908 769339 792390 398440 479810 545667 255858 454852 492758 500067 758553 828770 784693 767478 464724 706465 479527 400692 429594 456258 458726 595711 439445 442086 453434 467907 443202 461420 475703 524570 526621 483022 488259 490172 429723 468869 459022 ] |
||||||||||||||||||||||||||||||
|
3.26 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 185494 255858 384156 385475 392597 398440 400692 409933 424567 427857 429211 429301 429594 429723 432196 433855 433885 434230 435398 439445 442086 443202 448072 448885 452728 453434 454631 454852 455185 456258 456315 458726 459022 460009 460406 461420 461962 462020 463922 464724 467907 468869 469104 472085 474430 475703 476206 476557 476792 477797 479527 479810 480046 480096 483022 483878 485062 487775 487891 488259 490172 492398 492758 492798 494242 496492 496520 498078 500067 507517 509518 509614 509699 509780 510330 511518 511868 512019 512733 514731 515465 515507 517859 517908 518809 519229 519397 519530 520817 521055 521396 521803 522011 522551 524075 524570 524657 526621 528276 529072 538228 545667 555786 559222 595711 603286 695796 702136 706465 716203 716230 738325 758553 767478 769339 784693 787702 792390 828445 828770 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum panties bra"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum трусик нижн бел бюстгалтер нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum трусик нижн бел бюстгалтер нижн бел"
]
|
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.