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

[
  "aunt big ass"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'aunt big ass' 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
  385376
  518871
  808044
  411942
  504174
  520590
  518872
  428142
  497964
  430215
  492329
  475316
  512955
  502505
  522507
  529335
  526898
  564648
  563211
  790015
  403010
  443757
  474793
  523773
  489971
  514008
  446031
  442301
  486800
  537649
  466204
  453959
  394376
  425967
  443138
  442195
  442204
  528087
  466910
  453109
  465952
  519147
  484580
  442975
  557534
  446038
  523771
  469530
  467975
  527006
  472299
  450785
  469539
  454027
  457034
  465391
  559927
  403425
  482240
  417978
  442332
  486897
  527000
  469552
  494987
  561381
  466094
  462098
  484694
  484688
  430635
  467981
]

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 (385376, 518871, 808044, 411942, 504174, 520590, 518872, 428142, 497964, 430215, 492329, 475316, 512955, 502505, 522507, 529335, 526898, 564648, 563211, 790015, 403010, 443757, 474793, 523773, 489971, 514008, 446031, 442301, 486800, 537649, 466204, 453959, 394376, 425967, 443138, 442195, 442204, 528087, 466910, 453109, 465952, 519147, 484580, 442975, 557534, 446038, 523771, 469530, 467975, 527006, 472299, 450785, 469539, 454027, 457034, 465391, 559927, 403425, 482240, 417978, 442332, 486897, 527000, 469552, 494987, 561381, 466094, 462098, 484694, 484688, 430635, 467981);

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
  385376
  394376
  403010
  403425
  411942
  417978
  425967
  428142
  430215
  430635
  442195
  442204
  442301
  442332
  442975
  443138
  443757
  446031
  446038
  450785
  453109
  453959
  454027
  457034
  462098
  465391
  465952
  466094
  466204
  466910
  467975
  467981
  469530
  469539
  469552
  472299
  474793
  475316
  482240
  484580
  484688
  484694
  486800
  486897
  489971
  492329
  494987
  497964
  502505
  504174
  512955
  514008
  518871
  518872
  519147
  520590
  522507
  523771
  523773
  526898
  527000
  527006
  528087
  529335
  537649
  557534
  559927
  561381
  563211
  564648
  790015
  808044
]

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 (385376, 394376, 403010, 403425, 411942, 417978, 425967, 428142, 430215, 430635, 442195, 442204, 442301, 442332, 442975, 443138, 443757, 446031, 446038, 450785, 453109, 453959, 454027, 457034, 462098, 465391, 465952, 466094, 466204, 466910, 467975, 467981, 469530, 469539, 469552, 472299, 474793, 475316, 482240, 484580, 484688, 484694, 486800, 486897, 489971, 492329, 494987, 497964, 502505, 504174, 512955, 514008, 518871, 518872, 519147, 520590, 522507, 523771, 523773, 526898, 527000, 527006, 528087, 529335, 537649, 557534, 559927, 561381, 563211, 564648, 790015, 808044);

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
  385376
  394376
  403010
  403425
  411942
  417978
  425967
  428142
  430215
  430635
  442195
  442204
  442301
  442332
  442975
  443138
  443757
  446031
  446038
  450785
  453109
  453959
  454027
  457034
  462098
  465391
  465952
  466094
  466204
  466910
  467975
  467981
  469530
  469539
  469552
  472299
  474793
  475316
  482240
  484580
  484688
  484694
  486800
  486897
  489971
  492329
  494987
  497964
  502505
  504174
  512955
  514008
  518871
  518872
  519147
  520590
  522507
  523771
  523773
  526898
  527000
  527006
  528087
  529335
  537649
  557534
  559927
  561381
  563211
  564648
  790015
  808044
]

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 (385376, 394376, 403010, 403425, 411942, 417978, 425967, 428142, 430215, 430635, 442195, 442204, 442301, 442332, 442975, 443138, 443757, 446031, 446038, 450785, 453109, 453959, 454027, 457034, 462098, 465391, 465952, 466094, 466204, 466910, 467975, 467981, 469530, 469539, 469552, 472299, 474793, 475316, 482240, 484580, 484688, 484694, 486800, 486897, 489971, 492329, 494987, 497964, 502505, 504174, 512955, 514008, 518871, 518872, 519147, 520590, 522507, 523771, 523773, 526898, 527000, 527006, 528087, 529335, 537649, 557534, 559927, 561381, 563211, 564648, 790015, 808044);

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

[
  "aunt большая большие жоп"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'aunt большая большие жоп';

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

[
  "aunt большая большие жоп"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'aunt большая большие жоп';

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 ?

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