Query Metrics
7
Database Queries
7
Different statements
152.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.91 ms (83.14%) |
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 4463 212982 233674 390830 391344 391521 392031 392673 394200 397902 401004 402960 411399 419534 425931 443690 444671 446643 448715 451463 454555 465382 465390 465560 465822 465895 466039 466114 466318 466319 466380 467427 467621 468679 470172 470307 470927 470931 472676 474123 474484 474491 474946 479024 479026 479136 479139 479141 479145 484373 485081 485275 485358 485365 490106 490406 490872 490873 490892 490895 490913 490920 490921 490927 490928 490932 491906 491950 491966 491977 491989 492001 492100 493021 493972 503471 509427 509432 511538 512515 515596 516927 517553 517559 518849 520750 522078 522620 522744 522961 523148 526882 531282 541406 544183 546715 546928 546973 561348 562965 562999 563214 563220 563221 563227 567433 600813 619235 621376 644622 658463 683284 695380 695598 695691 746048 754581 805315 809339 827001 ] |
||||||||||||||||||||||||||||||
|
17.60 ms (11.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 212982 541406 491950 522620 466318 474123 600813 391344 394200 546973 448715 562965 546715 491989 474484 233674 485275 493972 425931 490106 491906 411399 523148 391521 479024 531282 517553 392673 443690 472676 827001 805315 446643 567433 444671 474946 509427 490927 470927 490913 491977 512515 695380 392031 563221 467621 522961 503471 465895 466380 470307 479141 401004 522744 526882 490873 518849 492001 563214 492100 465822 4463 562999 479139 746048 490892 511538 465390 397902 466114 479136 466319 474491 563220 658463 544183 470931 485358 490932 619235 546928 390830 479026 490921 485081 563227 467427 490406 490920 754581 479145 490872 695598 468679 520750 522078 484373 561348 644622 621376 454555 466039 419534 515596 470172 491966 465560 451463 517559 683284 809339 402960 465382 490928 485365 695691 490895 516927 509432 493021 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.49%) |
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 4463 212982 233674 390830 391344 391521 392031 392673 394200 397902 401004 402960 411399 419534 425931 443690 444671 446643 448715 451463 454555 465382 465390 465560 465822 465895 466039 466114 466318 466319 466380 467427 467621 468679 470172 470307 470927 470931 472676 474123 474484 474491 474946 479024 479026 479136 479139 479141 479145 484373 485081 485275 485358 485365 490106 490406 490872 490873 490892 490895 490913 490920 490921 490927 490928 490932 491906 491950 491966 491977 491989 492001 492100 493021 493972 503471 509427 509432 511538 512515 515596 516927 517553 517559 518849 520750 522078 522620 522744 522961 523148 526882 531282 541406 544183 546715 546928 546973 561348 562965 562999 563214 563220 563221 563227 567433 600813 619235 621376 644622 658463 683284 695380 695598 695691 746048 754581 805315 809339 827001 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"office russian mature"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секретарш русск mature"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.10 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секретарш русск mature"
]
|
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.