Query Metrics
7
Database Queries
7
Different statements
151.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.72 ms (83.02%) |
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 388604 400209 401957 415567 415598 421155 421942 429561 430351 430495 431750 443158 443692 443722 444468 446204 446968 450399 450608 452616 453702 454041 454432 455957 456605 457194 458378 458714 458724 458725 458928 460135 460178 460191 460262 460658 460677 461019 464189 464416 464552 465331 465838 466368 471397 471609 476263 477337 478931 482251 485456 486540 492138 492309 492366 502812 504091 505973 506833 511016 513362 513376 513707 516476 516829 518046 518155 518160 518267 518847 518859 519931 521391 521997 523902 525233 526226 526521 526527 528084 528347 528839 533425 537122 537126 541535 549236 551923 553672 561590 563141 563436 563455 578124 580061 581716 583756 584765 587915 589628 589682 605484 608350 609759 613286 619717 676591 697909 699596 706294 721724 726577 726882 729678 736399 748241 753205 756803 761275 ] |
||||||||||||||||||||||||||||||
|
16.56 ms (10.93%) |
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 492138 492366 549236 553672 561590 580061 584765 551923 563436 581716 563455 699596 676582 697909 706294 721724 563141 578124 583756 587915 609759 589628 605484 613286 589682 729678 753205 736399 748241 756803 726577 726882 608350 401957 464189 464416 478931 482251 431750 460191 477337 415598 458724 461019 471397 471609 430351 443692 443722 450399 452616 454041 460178 465331 466368 518267 513376 516829 518046 485456 513362 521997 523902 526226 526521 505973 518859 521391 525233 526527 400209 528084 513707 676591 458725 460658 504091 528839 761275 619717 421155 486540 429561 519931 388604 421942 415567 444468 430495 443158 446968 450608 453702 454432 455957 456605 458714 458928 464552 446204 457194 458378 460135 465838 476263 518155 537126 506833 511016 518847 528347 537122 502812 516476 518160 533425 460262 460677 492309 541535 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.69%) |
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 388604 400209 401957 415567 415598 421155 421942 429561 430351 430495 431750 443158 443692 443722 444468 446204 446968 450399 450608 452616 453702 454041 454432 455957 456605 457194 458378 458714 458724 458725 458928 460135 460178 460191 460262 460658 460677 461019 464189 464416 464552 465331 465838 466368 471397 471609 476263 477337 478931 482251 485456 486540 492138 492309 492366 502812 504091 505973 506833 511016 513362 513376 513707 516476 516829 518046 518155 518160 518267 518847 518859 519931 521391 521997 523902 525233 526226 526521 526527 528084 528347 528839 533425 537122 537126 541535 549236 551923 553672 561590 563141 563436 563455 578124 580061 581716 583756 584765 587915 589628 589682 605484 608350 609759 613286 619717 676591 697909 699596 706294 721724 726577 726882 729678 736399 748241 753205 756803 761275 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom cock son"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom cock son"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom cock son"
]
|
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.