Query Metrics
7
Database Queries
7
Different statements
159.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.54 ms (84.29%) |
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 30680 83312 151163 373048 384871 387200 398685 400677 401559 414183 419101 420464 423963 425249 425921 426654 427429 429603 440257 445731 448273 449643 453341 454756 455278 456027 456220 456319 457862 458127 458658 459092 460151 461367 465263 465692 468699 469170 469651 470086 470828 476007 476553 478100 479299 480304 480922 486561 486565 489167 490270 492278 492468 492477 495130 497284 497545 498210 498234 503944 504610 504620 505812 509537 510675 510723 515481 518299 521825 522615 523174 523510 529441 531608 540476 542108 543123 546885 549541 555569 555672 559974 565413 566025 577607 585776 589391 591706 593098 593403 598757 599410 599764 602712 602774 602936 603812 618301 636178 638479 639331 660090 691897 728348 731471 737425 754878 764944 765062 791971 798706 798907 799016 799893 804739 804821 807876 812779 822635 825847 ] |
||||||||||||||||||||||||||||||
|
15.01 ms (9.40%) |
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 791971 453341 798907 602936 458658 400677 798706 799893 765062 531608 804739 822635 639331 426654 603812 504610 151163 30680 458127 577607 660090 509537 549541 445731 555672 456027 414183 465263 498210 638479 505812 825847 83312 518299 480922 591706 495130 497545 602712 737425 546885 460151 804821 455278 459092 457862 427429 559974 470086 599764 492278 540476 691897 504620 510723 419101 522615 398685 543123 585776 754878 425921 449643 470828 523510 387200 764944 731471 469170 593403 425249 492468 497284 461367 529441 807876 456319 523174 555569 566025 598757 486565 420464 521825 384871 478100 465692 599410 373048 480304 440257 492477 515481 486561 454756 448273 476007 490270 799016 468699 728348 593098 456220 636178 489167 589391 401559 542108 602774 618301 429603 469651 498234 423963 812779 476553 510675 479299 565413 503944 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.75%) |
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 30680 83312 151163 373048 384871 387200 398685 400677 401559 414183 419101 420464 423963 425249 425921 426654 427429 429603 440257 445731 448273 449643 453341 454756 455278 456027 456220 456319 457862 458127 458658 459092 460151 461367 465263 465692 468699 469170 469651 470086 470828 476007 476553 478100 479299 480304 480922 486561 486565 489167 490270 492278 492468 492477 495130 497284 497545 498210 498234 503944 504610 504620 505812 509537 510675 510723 515481 518299 521825 522615 523174 523510 529441 531608 540476 542108 543123 546885 549541 555569 555672 559974 565413 566025 577607 585776 589391 591706 593098 593403 598757 599410 599764 602712 602774 602936 603812 618301 636178 638479 639331 660090 691897 728348 731471 737425 754878 764944 765062 791971 798706 798907 799016 799893 804739 804821 807876 812779 822635 825847 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck car"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс вмашин"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.92%) |
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.