Query Metrics
7
Database Queries
7
Different statements
179.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.63 ms (83.32%) |
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 129999 188420 368586 383474 393756 394376 400423 402067 403591 405936 414785 415698 419547 420584 423298 424288 424424 424923 427978 428497 432707 433445 435022 441972 442063 443461 443833 444053 445706 449100 450316 451452 452259 452623 453235 453325 457484 457866 457899 458682 460007 460071 460590 462841 463072 464706 465008 466081 466557 467035 469878 470742 475208 475931 476608 476863 477455 477941 479315 484423 484600 485359 486300 486791 486894 490132 492616 493274 494710 496226 498248 502663 504036 505235 506148 506935 508478 508983 512600 513953 515201 516791 517088 518837 520052 520360 522091 522971 522980 523150 525756 526024 529438 537161 538216 542934 545262 546964 547649 551437 552265 554292 558072 562109 562412 562978 563133 563166 567187 571500 577898 591715 595708 599497 653764 683310 707706 730120 735501 772753 ] |
||||||||||||||||||||||||||||||
|
19.58 ms (10.91%) |
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 393756 453325 542934 571500 552265 475208 419547 469878 508983 484600 492616 129999 537161 772753 444053 577898 591715 383474 435022 518837 520052 485359 504036 505235 427978 653764 520360 562109 462841 479315 484423 493274 546964 523150 595708 707706 512600 506148 368586 730120 538216 558072 464706 414785 403591 443461 405936 562978 506935 394376 451452 458682 424288 508478 502663 423298 449100 551437 567187 457899 463072 465008 494710 424923 460590 486300 554292 432707 450316 460007 477941 476608 547649 496226 490132 420584 545262 453235 683310 433445 442063 457866 562412 599497 452259 460071 476863 563166 457484 735501 516791 522091 522971 477455 522980 498248 443833 424424 513953 526024 529438 415698 563133 445706 470742 486894 452623 400423 441972 402067 188420 466557 486791 525756 475931 517088 428497 515201 466081 467035 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (1.87%) |
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 129999 188420 368586 383474 393756 394376 400423 402067 403591 405936 414785 415698 419547 420584 423298 424288 424424 424923 427978 428497 432707 433445 435022 441972 442063 443461 443833 444053 445706 449100 450316 451452 452259 452623 453235 453325 457484 457866 457899 458682 460007 460071 460590 462841 463072 464706 465008 466081 466557 467035 469878 470742 475208 475931 476608 476863 477455 477941 479315 484423 484600 485359 486300 486791 486894 490132 492616 493274 494710 496226 498248 502663 504036 505235 506148 506935 508478 508983 512600 513953 515201 516791 517088 518837 520052 520360 522091 522971 522980 523150 525756 526024 529438 537161 538216 542934 545262 546964 547649 551437 552265 554292 558072 562109 562412 562978 563133 563166 567187 571500 577898 591715 595708 599497 653764 683310 707706 730120 735501 772753 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс в позе 69"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс поз 69"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс поз 69"
]
|
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.