Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

[]

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1

[
  "touching girl"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'touching girl' LIMIT 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  784954
  526581
  385558
  814684
  775249
  745301
  824532
  495487
  542215
  606558
  796629
  769065
  526315
  516373
  497909
  510051
  494878
  396281
  439264
  472401
  522938
  485676
  529931
  383002
  584888
  553277
  700263
  627009
  642190
  571469
  696126
  599073
  813491
  411765
  464687
  518095
  487543
  555508
  525214
  507763
  536906
  553283
  627786
  788519
  552917
  549249
  621964
  612848
  536092
  529517
  814681
  563917
  410124
  561457
  650612
  623494
  623613
  414047
  496478
  518175
  476371
  519790
  528100
  566922
  598741
  576269
  555043
  726487
  522902
  556009
  538027
  603885
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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`=1 LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=2 WHERE p.post_id IN (784954, 526581, 385558, 814684, 775249, 745301, 824532, 495487, 542215, 606558, 796629, 769065, 526315, 516373, 497909, 510051, 494878, 396281, 439264, 472401, 522938, 485676, 529931, 383002, 584888, 553277, 700263, 627009, 642190, 571469, 696126, 599073, 813491, 411765, 464687, 518095, 487543, 555508, 525214, 507763, 536906, 553283, 627786, 788519, 552917, 549249, 621964, 612848, 536092, 529517, 814681, 563917, 410124, 561457, 650612, 623494, 623613, 414047, 496478, 518175, 476371, 519790, 528100, 566922, 598741, 576269, 555043, 726487, 522902, 556009, 538027, 603885);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  383002
  385558
  396281
  410124
  411765
  414047
  439264
  464687
  472401
  476371
  485676
  487543
  494878
  495487
  496478
  497909
  507763
  510051
  516373
  518095
  518175
  519790
  522902
  522938
  525214
  526315
  526581
  528100
  529517
  529931
  536092
  536906
  538027
  542215
  549249
  552917
  553277
  553283
  555043
  555508
  556009
  561457
  563917
  566922
  571469
  576269
  584888
  598741
  599073
  603885
  606558
  612848
  621964
  623494
  623613
  627009
  627786
  642190
  650612
  696126
  700263
  726487
  745301
  769065
  775249
  784954
  788519
  796629
  813491
  814681
  814684
  824532
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=2 WHERE pht.post_id IN (383002, 385558, 396281, 410124, 411765, 414047, 439264, 464687, 472401, 476371, 485676, 487543, 494878, 495487, 496478, 497909, 507763, 510051, 516373, 518095, 518175, 519790, 522902, 522938, 525214, 526315, 526581, 528100, 529517, 529931, 536092, 536906, 538027, 542215, 549249, 552917, 553277, 553283, 555043, 555508, 556009, 561457, 563917, 566922, 571469, 576269, 584888, 598741, 599073, 603885, 606558, 612848, 621964, 623494, 623613, 627009, 627786, 642190, 650612, 696126, 700263, 726487, 745301, 769065, 775249, 784954, 788519, 796629, 813491, 814681, 814684, 824532);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  383002
  385558
  396281
  410124
  411765
  414047
  439264
  464687
  472401
  476371
  485676
  487543
  494878
  495487
  496478
  497909
  507763
  510051
  516373
  518095
  518175
  519790
  522902
  522938
  525214
  526315
  526581
  528100
  529517
  529931
  536092
  536906
  538027
  542215
  549249
  552917
  553277
  553283
  555043
  555508
  556009
  561457
  563917
  566922
  571469
  576269
  584888
  598741
  599073
  603885
  606558
  612848
  621964
  623494
  623613
  627009
  627786
  642190
  650612
  696126
  700263
  726487
  745301
  769065
  775249
  784954
  788519
  796629
  813491
  814681
  814684
  824532
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=2 WHERE phc.post_id IN (383002, 385558, 396281, 410124, 411765, 414047, 439264, 464687, 472401, 476371, 485676, 487543, 494878, 495487, 496478, 497909, 507763, 510051, 516373, 518095, 518175, 519790, 522902, 522938, 525214, 526315, 526581, 528100, 529517, 529931, 536092, 536906, 538027, 542215, 549249, 552917, 553277, 553283, 555043, 555508, 556009, 561457, 563917, 566922, 571469, 576269, 584888, 598741, 599073, 603885, 606558, 612848, 621964, 623494, 623613, 627009, 627786, 642190, 650612, 696126, 700263, 726487, 745301, 769065, 775249, 784954, 788519, 796629, 813491, 814681, 814684, 824532);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "touching девушк"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'touching девушк';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "touching девушк"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'touching девушк';

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

[
  "touching girl"
  "touching girl"
  "touching girl"
  20
]

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('touching girl') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('touching girl')
              AND `query` <> 'touching girl'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;