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

[
  "green hair"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'green hair' 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
  790927
  617212
  428732
  415558
  822960
  820641
  817903
  721188
  605285
  763850
  452412
  419410
  492789
  657743
  670360
  690066
  564939
  812428
  446704
  491684
  526561
  527113
  452400
  446614
  517180
  575208
  579957
  686130
  581737
  602450
  755437
  456176
  525107
  454428
  453938
  564473
  660416
  586652
  624299
  598833
  605026
  624282
  755079
  764359
  437544
  508246
  425967
  452418
  547494
  552567
  565556
  446642
  523861
  484078
  495310
  535010
  439783
  419113
  513113
  515160
  422652
  492572
  582531
  588637
  603286
  464366
  523793
  508441
  632261
  591585
  477686
  515185
  621732
  514997
]

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 (790927, 617212, 428732, 415558, 822960, 820641, 817903, 721188, 605285, 763850, 452412, 419410, 492789, 657743, 670360, 690066, 564939, 812428, 446704, 491684, 526561, 527113, 452400, 446614, 517180, 575208, 579957, 686130, 581737, 602450, 755437, 456176, 525107, 454428, 453938, 564473, 660416, 586652, 624299, 598833, 605026, 624282, 755079, 764359, 437544, 508246, 425967, 452418, 547494, 552567, 565556, 446642, 523861, 484078, 495310, 535010, 439783, 419113, 513113, 515160, 422652, 492572, 582531, 588637, 603286, 464366, 523793, 508441, 632261, 591585, 477686, 515185, 621732, 514997);

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
  415558
  419113
  419410
  422652
  425967
  428732
  437544
  439783
  446614
  446642
  446704
  452400
  452412
  452418
  453938
  454428
  456176
  464366
  477686
  484078
  491684
  492572
  492789
  495310
  508246
  508441
  513113
  514997
  515160
  515185
  517180
  523793
  523861
  525107
  526561
  527113
  535010
  547494
  552567
  564473
  564939
  565556
  575208
  579957
  581737
  582531
  586652
  588637
  591585
  598833
  602450
  603286
  605026
  605285
  617212
  621732
  624282
  624299
  632261
  657743
  660416
  670360
  686130
  690066
  721188
  755079
  755437
  763850
  764359
  790927
  812428
  817903
  820641
  822960
]

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 (415558, 419113, 419410, 422652, 425967, 428732, 437544, 439783, 446614, 446642, 446704, 452400, 452412, 452418, 453938, 454428, 456176, 464366, 477686, 484078, 491684, 492572, 492789, 495310, 508246, 508441, 513113, 514997, 515160, 515185, 517180, 523793, 523861, 525107, 526561, 527113, 535010, 547494, 552567, 564473, 564939, 565556, 575208, 579957, 581737, 582531, 586652, 588637, 591585, 598833, 602450, 603286, 605026, 605285, 617212, 621732, 624282, 624299, 632261, 657743, 660416, 670360, 686130, 690066, 721188, 755079, 755437, 763850, 764359, 790927, 812428, 817903, 820641, 822960);

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
  415558
  419113
  419410
  422652
  425967
  428732
  437544
  439783
  446614
  446642
  446704
  452400
  452412
  452418
  453938
  454428
  456176
  464366
  477686
  484078
  491684
  492572
  492789
  495310
  508246
  508441
  513113
  514997
  515160
  515185
  517180
  523793
  523861
  525107
  526561
  527113
  535010
  547494
  552567
  564473
  564939
  565556
  575208
  579957
  581737
  582531
  586652
  588637
  591585
  598833
  602450
  603286
  605026
  605285
  617212
  621732
  624282
  624299
  632261
  657743
  660416
  670360
  686130
  690066
  721188
  755079
  755437
  763850
  764359
  790927
  812428
  817903
  820641
  822960
]

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 (415558, 419113, 419410, 422652, 425967, 428732, 437544, 439783, 446614, 446642, 446704, 452400, 452412, 452418, 453938, 454428, 456176, 464366, 477686, 484078, 491684, 492572, 492789, 495310, 508246, 508441, 513113, 514997, 515160, 515185, 517180, 523793, 523861, 525107, 526561, 527113, 535010, 547494, 552567, 564473, 564939, 565556, 575208, 579957, 581737, 582531, 586652, 588637, 591585, 598833, 602450, 603286, 605026, 605285, 617212, 621732, 624282, 624299, 632261, 657743, 660416, 670360, 686130, 690066, 721188, 755079, 755437, 763850, 764359, 790927, 812428, 817903, 820641, 822960);

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

[
  "green hair"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'green hair';

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

[
  "green hair"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'green hair';

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 ?

[
  "green hair"
  "green hair"
  "green hair"
  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 ('green hair') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('green hair')
              AND `query` <> 'green hair'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;