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

[
  "bathroom family"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'bathroom family' 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
  700818
  787935
  802196
  441683
  594566
  443757
  599692
  684235
  674784
  763380
  824581
  597981
  564088
  775710
  806164
  586618
  663968
  598973
  559554
  570970
  698039
  663393
  557206
  753775
  467981
  579785
  544342
  728102
  447574
  457179
  530880
  577142
  663442
  741893
  756279
  716299
  405742
  632715
  491700
  575997
  565447
  589335
  404612
  457186
  584567
  800936
  436730
  520382
  467975
  589486
  479473
  431052
  505310
  566243
  541876
  649174
  625436
  534227
  469539
  454872
  541656
  633165
  587193
  442946
  454875
  638557
  589666
  525171
  496098
  617342
  520803
  407168
]

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 (700818, 787935, 802196, 441683, 594566, 443757, 599692, 684235, 674784, 763380, 824581, 597981, 564088, 775710, 806164, 586618, 663968, 598973, 559554, 570970, 698039, 663393, 557206, 753775, 467981, 579785, 544342, 728102, 447574, 457179, 530880, 577142, 663442, 741893, 756279, 716299, 405742, 632715, 491700, 575997, 565447, 589335, 404612, 457186, 584567, 800936, 436730, 520382, 467975, 589486, 479473, 431052, 505310, 566243, 541876, 649174, 625436, 534227, 469539, 454872, 541656, 633165, 587193, 442946, 454875, 638557, 589666, 525171, 496098, 617342, 520803, 407168);

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
  404612
  405742
  407168
  431052
  436730
  441683
  442946
  443757
  447574
  454872
  454875
  457179
  457186
  467975
  467981
  469539
  479473
  491700
  496098
  505310
  520382
  520803
  525171
  530880
  534227
  541656
  541876
  544342
  557206
  559554
  564088
  565447
  566243
  570970
  575997
  577142
  579785
  584567
  586618
  587193
  589335
  589486
  589666
  594566
  597981
  598973
  599692
  617342
  625436
  632715
  633165
  638557
  649174
  663393
  663442
  663968
  674784
  684235
  698039
  700818
  716299
  728102
  741893
  753775
  756279
  763380
  775710
  787935
  800936
  802196
  806164
  824581
]

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 (404612, 405742, 407168, 431052, 436730, 441683, 442946, 443757, 447574, 454872, 454875, 457179, 457186, 467975, 467981, 469539, 479473, 491700, 496098, 505310, 520382, 520803, 525171, 530880, 534227, 541656, 541876, 544342, 557206, 559554, 564088, 565447, 566243, 570970, 575997, 577142, 579785, 584567, 586618, 587193, 589335, 589486, 589666, 594566, 597981, 598973, 599692, 617342, 625436, 632715, 633165, 638557, 649174, 663393, 663442, 663968, 674784, 684235, 698039, 700818, 716299, 728102, 741893, 753775, 756279, 763380, 775710, 787935, 800936, 802196, 806164, 824581);

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
  404612
  405742
  407168
  431052
  436730
  441683
  442946
  443757
  447574
  454872
  454875
  457179
  457186
  467975
  467981
  469539
  479473
  491700
  496098
  505310
  520382
  520803
  525171
  530880
  534227
  541656
  541876
  544342
  557206
  559554
  564088
  565447
  566243
  570970
  575997
  577142
  579785
  584567
  586618
  587193
  589335
  589486
  589666
  594566
  597981
  598973
  599692
  617342
  625436
  632715
  633165
  638557
  649174
  663393
  663442
  663968
  674784
  684235
  698039
  700818
  716299
  728102
  741893
  753775
  756279
  763380
  775710
  787935
  800936
  802196
  806164
  824581
]

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 (404612, 405742, 407168, 431052, 436730, 441683, 442946, 443757, 447574, 454872, 454875, 457179, 457186, 467975, 467981, 469539, 479473, 491700, 496098, 505310, 520382, 520803, 525171, 530880, 534227, 541656, 541876, 544342, 557206, 559554, 564088, 565447, 566243, 570970, 575997, 577142, 579785, 584567, 586618, 587193, 589335, 589486, 589666, 594566, 597981, 598973, 599692, 617342, 625436, 632715, 633165, 638557, 649174, 663393, 663442, 663968, 674784, 684235, 698039, 700818, 716299, 728102, 741893, 753775, 756279, 763380, 775710, 787935, 800936, 802196, 806164, 824581);

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

[
  "ван family"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'ван family';

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

[
  "ван family"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'ван family';

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 ?

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