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

[
  "beach swingers"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'beach swingers' 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
  456859
  457780
  456896
  409379
  721888
  721968
  459178
  415505
  635684
  562372
  613599
  631185
  568180
  545210
  679415
  721972
  537017
  532361
  543757
  544956
  733150
  592884
  597873
  721933
  721885
  556001
  456883
  459161
  535897
  530312
  562366
  674514
  733153
  710509
  562953
  590188
  619822
  418567
  457781
  457770
  457674
  456688
  606574
  671893
  457788
  435844
  526277
  523046
  568193
  738440
  457783
  453068
  543597
  455020
  490201
  567467
  456858
  472930
  448307
  460957
  579900
  414184
  448316
  457776
  457290
  455016
  504098
  598097
  426547
  414204
  500901
  554751
  565095
]

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 (456859, 457780, 456896, 409379, 721888, 721968, 459178, 415505, 635684, 562372, 613599, 631185, 568180, 545210, 679415, 721972, 537017, 532361, 543757, 544956, 733150, 592884, 597873, 721933, 721885, 556001, 456883, 459161, 535897, 530312, 562366, 674514, 733153, 710509, 562953, 590188, 619822, 418567, 457781, 457770, 457674, 456688, 606574, 671893, 457788, 435844, 526277, 523046, 568193, 738440, 457783, 453068, 543597, 455020, 490201, 567467, 456858, 472930, 448307, 460957, 579900, 414184, 448316, 457776, 457290, 455016, 504098, 598097, 426547, 414204, 500901, 554751, 565095);

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
  409379
  414184
  414204
  415505
  418567
  426547
  435844
  448307
  448316
  453068
  455016
  455020
  456688
  456858
  456859
  456883
  456896
  457290
  457674
  457770
  457776
  457780
  457781
  457783
  457788
  459161
  459178
  460957
  472930
  490201
  500901
  504098
  523046
  526277
  530312
  532361
  535897
  537017
  543597
  543757
  544956
  545210
  554751
  556001
  562366
  562372
  562953
  565095
  567467
  568180
  568193
  579900
  590188
  592884
  597873
  598097
  606574
  613599
  619822
  631185
  635684
  671893
  674514
  679415
  710509
  721885
  721888
  721933
  721968
  721972
  733150
  733153
  738440
]

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 (409379, 414184, 414204, 415505, 418567, 426547, 435844, 448307, 448316, 453068, 455016, 455020, 456688, 456858, 456859, 456883, 456896, 457290, 457674, 457770, 457776, 457780, 457781, 457783, 457788, 459161, 459178, 460957, 472930, 490201, 500901, 504098, 523046, 526277, 530312, 532361, 535897, 537017, 543597, 543757, 544956, 545210, 554751, 556001, 562366, 562372, 562953, 565095, 567467, 568180, 568193, 579900, 590188, 592884, 597873, 598097, 606574, 613599, 619822, 631185, 635684, 671893, 674514, 679415, 710509, 721885, 721888, 721933, 721968, 721972, 733150, 733153, 738440);

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
  409379
  414184
  414204
  415505
  418567
  426547
  435844
  448307
  448316
  453068
  455016
  455020
  456688
  456858
  456859
  456883
  456896
  457290
  457674
  457770
  457776
  457780
  457781
  457783
  457788
  459161
  459178
  460957
  472930
  490201
  500901
  504098
  523046
  526277
  530312
  532361
  535897
  537017
  543597
  543757
  544956
  545210
  554751
  556001
  562366
  562372
  562953
  565095
  567467
  568180
  568193
  579900
  590188
  592884
  597873
  598097
  606574
  613599
  619822
  631185
  635684
  671893
  674514
  679415
  710509
  721885
  721888
  721933
  721968
  721972
  733150
  733153
  738440
]

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 (409379, 414184, 414204, 415505, 418567, 426547, 435844, 448307, 448316, 453068, 455016, 455020, 456688, 456858, 456859, 456883, 456896, 457290, 457674, 457770, 457776, 457780, 457781, 457783, 457788, 459161, 459178, 460957, 472930, 490201, 500901, 504098, 523046, 526277, 530312, 532361, 535897, 537017, 543597, 543757, 544956, 545210, 554751, 556001, 562366, 562372, 562953, 565095, 567467, 568180, 568193, 579900, 590188, 592884, 597873, 598097, 606574, 613599, 619822, 631185, 635684, 671893, 674514, 679415, 710509, 721885, 721888, 721933, 721968, 721972, 733150, 733153, 738440);

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

[
  "пляж природ свингер"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'пляж природ свингер';

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

[
  "пляж природ свингер"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'пляж природ свингер';

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 ?

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