Query Metrics
7
Database Queries
7
Different statements
200.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
180.03 ms (89.84%) |
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 191117 384082 399959 399973 410851 412525 418774 418890 423348 424566 432207 435221 435802 435822 444839 445029 445977 446243 446981 447771 452825 453774 455398 456664 456667 456911 463986 470731 472416 476054 480829 482249 483051 486169 486559 486705 489818 490519 492412 495242 500843 503482 505665 511636 511903 512219 515330 515779 519983 520534 521625 523058 523373 525173 525979 526320 526327 526407 528223 529052 532595 532885 539405 544401 546358 548167 548170 548537 550606 555442 556345 559700 559836 562386 563361 564218 566344 569163 571050 571203 571789 573400 575009 577553 577726 577775 578501 579964 580746 581659 584904 585381 586005 589519 591107 592917 595611 595986 597692 598462 600242 601138 601519 603302 611192 611327 617961 619394 619612 624923 625227 625762 627049 636647 654521 674240 677147 681027 734842 ] |
||||||||||||||||||||||||||||||
|
11.61 ms (5.79%) |
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 555442 636647 597692 617961 592917 601138 591806 625762 611192 611327 384082 445977 563361 674240 601519 399973 523058 550606 546358 548170 562386 571050 581659 548537 577775 584904 585381 446243 486705 435221 456664 523373 520534 528223 500843 515779 515330 559700 577726 654521 548167 595611 619394 624923 423348 456911 476054 418774 432207 435822 412525 445029 452825 418890 424566 446981 470731 489818 511636 410851 456667 463986 447771 505665 529052 532595 532885 539405 544401 556345 564218 573400 559836 575009 577553 580746 569163 571789 681027 677147 566344 571203 578501 579964 589519 598462 603302 619612 627049 586005 591107 595986 600242 625227 734842 399959 444839 455398 435802 483051 191117 480829 486169 486559 472416 482249 453774 490519 492412 495242 511903 512219 525173 526327 521625 525979 526320 526407 503482 519983 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.27%) |
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 191117 384082 399959 399973 410851 412525 418774 418890 423348 424566 432207 435221 435802 435822 444839 445029 445977 446243 446981 447771 452825 453774 455398 456664 456667 456911 463986 470731 472416 476054 480829 482249 483051 486169 486559 486705 489818 490519 492412 495242 500843 503482 505665 511636 511903 512219 515330 515779 519983 520534 521625 523058 523373 525173 525979 526320 526327 526407 528223 529052 532595 532885 539405 544401 546358 548167 548170 548537 550606 555442 556345 559700 559836 562386 563361 564218 566344 569163 571050 571203 571789 573400 575009 577553 577726 577775 578501 579964 580746 581659 584904 585381 586005 589519 591107 592917 595611 595986 597692 598462 600242 601138 601519 603302 611192 611327 617961 619394 619612 624923 625227 625762 627049 636647 654521 674240 677147 681027 734842 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"finger for girl"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"палец девушк"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.15 ms (0.57%) |
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.