Query Metrics
7
Database Queries
7
Different statements
170.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.54 ms (83.97%) |
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 421848 421881 433323 439631 439676 439816 444346 449925 450544 453493 453710 455465 456684 460281 460338 460370 461840 464835 465313 466077 466342 476950 478374 482248 483569 484713 485460 486336 486884 488812 491208 492799 496575 496854 497779 500803 503702 503975 504897 506941 509440 510824 511791 511844 513954 516119 517708 519128 519493 520145 520657 521021 521115 523829 524083 524135 524323 525197 526066 526587 528212 528428 528528 528708 528877 528927 532331 532604 533137 538333 539739 539744 539745 539758 543425 543434 545832 549822 550475 556009 559617 561458 562028 562061 565578 566850 571103 572711 578631 582444 586713 586786 589683 591065 592862 593296 596929 597736 598214 599482 602672 602790 605971 606019 608041 611283 616978 619201 619836 620252 621203 621655 623089 623150 625441 627773 638115 668140 680428 682303 ] |
||||||||||||||||||||||||||||||
|
18.01 ms (10.53%) |
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 524083 562028 582444 566850 571103 549822 598214 616978 620252 421848 478374 460338 461840 421881 476950 513954 517708 528212 503702 496854 511844 523829 528708 597736 520145 621203 578631 559617 466342 504897 491208 516119 503975 511791 509440 619836 525197 510824 521115 482248 528428 519128 539739 680428 556009 623150 455465 439816 460370 526587 543425 611283 439676 538333 519493 465313 524135 497779 586713 492799 602790 496575 520657 453493 453710 539744 506941 521021 532331 526066 532604 539758 486884 439631 466077 450544 456684 464835 500803 528877 621655 543434 562061 565578 606019 619201 589683 638115 668140 539745 602672 608041 528927 533137 550475 625441 444346 485460 524323 627773 486336 605971 460281 488812 682303 623089 593296 596929 599482 592862 433323 484713 483569 528528 586786 572711 561458 449925 591065 545832 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.44%) |
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 421848 421881 433323 439631 439676 439816 444346 449925 450544 453493 453710 455465 456684 460281 460338 460370 461840 464835 465313 466077 466342 476950 478374 482248 483569 484713 485460 486336 486884 488812 491208 492799 496575 496854 497779 500803 503702 503975 504897 506941 509440 510824 511791 511844 513954 516119 517708 519128 519493 520145 520657 521021 521115 523829 524083 524135 524323 525197 526066 526587 528212 528428 528528 528708 528877 528927 532331 532604 533137 538333 539739 539744 539745 539758 543425 543434 545832 549822 550475 556009 559617 561458 562028 562061 565578 566850 571103 572711 578631 582444 586713 586786 589683 591065 592862 593296 596929 597736 598214 599482 602672 602790 605971 606019 608041 611283 616978 619201 619836 620252 621203 621655 623089 623150 625441 627773 638115 668140 680428 682303 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"Ðüð╝ð¥ÐéÐÇðÁÐéÐî ðÂðÁð¢ð░ ð▓ Ðàð░ð╗ð░ÐéðÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"смотрет жен в халат"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.88%) |
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.