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 sex swingers"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'beach sex 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
  409379
  721888
  459178
  721968
  415505
  635684
  631185
  562372
  613599
  568180
  545210
  721972
  537017
  733150
  543757
  532361
  592884
  597873
  544956
  721933
  456859
  535897
  456896
  456883
  459161
  721885
  530312
  562366
  556001
  674514
  710509
  733153
  562953
  418567
  590188
  619822
  457781
  457674
  456688
  457770
  606574
  671893
  435844
  738440
  568193
  457788
  526277
  523046
  457783
  543597
  455020
  453068
  490201
  567467
  457780
  456858
  472930
  448307
  460957
  579900
  414184
  448316
  457776
  457290
  455016
  504098
  598097
  414204
  500901
  426547
  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 (409379, 721888, 459178, 721968, 415505, 635684, 631185, 562372, 613599, 568180, 545210, 721972, 537017, 733150, 543757, 532361, 592884, 597873, 544956, 721933, 456859, 535897, 456896, 456883, 459161, 721885, 530312, 562366, 556001, 674514, 710509, 733153, 562953, 418567, 590188, 619822, 457781, 457674, 456688, 457770, 606574, 671893, 435844, 738440, 568193, 457788, 526277, 523046, 457783, 543597, 455020, 453068, 490201, 567467, 457780, 456858, 472930, 448307, 460957, 579900, 414184, 448316, 457776, 457290, 455016, 504098, 598097, 414204, 500901, 426547, 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
  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, 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
  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, 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 sex swingers"
  "beach sex swingers"
  "beach sex 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 sex swingers') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('beach sex swingers')
              AND `query` <> 'beach sex swingers'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;