Query Metrics
7
Database Queries
7
Different statements
158.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.05 ms (84.34%) |
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 438514 446329 464809 479719 479731 498983 499252 499525 505772 510819 513617 522703 524260 524272 524651 526481 531501 532072 532082 533211 533502 535490 537697 537714 538355 540257 540460 544330 544333 544335 544344 544345 544351 544380 547259 547283 547289 547321 547322 547339 548271 549262 549275 549277 549288 549339 549342 549366 549385 549394 549425 549875 549945 549961 549988 550518 550627 551710 551711 552189 552232 552433 557152 562408 565309 568239 570774 570780 570787 570798 570799 570800 570803 570805 570806 570826 572561 572572 572577 572586 572612 573319 576857 579910 579930 583841 583869 586152 586826 595021 597118 603279 606712 607501 612288 615990 625922 633638 644254 650245 655479 658250 659282 668425 668438 676619 677700 684202 692133 699645 705297 705298 705300 707271 707274 724073 740619 744802 780719 808886 ] |
||||||||||||||||||||||||||||||
|
14.89 ms (9.37%) |
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 549425 572561 438514 547283 573319 531501 633638 524272 544351 549262 677700 505772 540257 513617 570799 549945 549342 550518 547322 615990 547339 586152 549275 544345 570805 655479 676619 526481 551710 707271 583869 547289 744802 544330 557152 705300 549277 562408 549385 570774 552433 549366 549875 549288 535490 533211 532082 572572 570780 707274 612288 579910 510819 606712 499525 552232 576857 549339 548271 552189 565309 586826 597118 532072 544333 544335 572586 550627 579930 692133 650245 572577 644254 479719 479731 607501 568239 603279 544344 537714 668438 705298 659282 595021 538355 544380 551711 570800 547259 570798 684202 570826 583841 499252 572612 524260 524651 464809 549961 547321 570803 808886 498983 537697 658250 780719 724073 446329 570787 699645 533502 668425 740619 540460 570806 549394 549988 705297 625922 522703 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.66%) |
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 438514 446329 464809 479719 479731 498983 499252 499525 505772 510819 513617 522703 524260 524272 524651 526481 531501 532072 532082 533211 533502 535490 537697 537714 538355 540257 540460 544330 544333 544335 544344 544345 544351 544380 547259 547283 547289 547321 547322 547339 548271 549262 549275 549277 549288 549339 549342 549366 549385 549394 549425 549875 549945 549961 549988 550518 550627 551710 551711 552189 552232 552433 557152 562408 565309 568239 570774 570780 570787 570798 570799 570800 570803 570805 570806 570826 572561 572572 572577 572586 572612 573319 576857 579910 579930 583841 583869 586152 586826 595021 597118 603279 606712 607501 612288 615990 625922 633638 644254 650245 655479 658250 659282 668425 668438 676619 677700 684202 692133 699645 705297 705298 705300 707271 707274 724073 740619 744802 780719 808886 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex erotic"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс эротик"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.99%) |
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.