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

[
  "hot horny girl"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'hot horny girl' 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
  556654
  658445
  695153
  621343
  401902
  440079
  487469
  565959
  810665
  408539
  511341
  584656
  585703
  637245
  493037
  704218
  624905
  641414
  787075
  455876
  525360
  602607
  477361
  526420
  515604
  804104
  419159
  562951
  714743
  626066
  610931
  788994
  421073
  459401
  518201
  518589
  400233
  625171
  528149
  600864
  791048
  421357
  533289
  491478
  605395
  447315
  520627
  466930
  552270
  590079
  437598
  402141
  522441
  523814
  546015
  514768
  508554
  446148
  463773
  527243
  544486
  593534
  524560
  527232
  522604
  566761
  536903
  581720
  528093
  523172
  460612
  454709
  461906
  632579
  456518
  653325
  560176
  584873
  621265
  589048
]

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 (556654, 658445, 695153, 621343, 401902, 440079, 487469, 565959, 810665, 408539, 511341, 584656, 585703, 637245, 493037, 704218, 624905, 641414, 787075, 455876, 525360, 602607, 477361, 526420, 515604, 804104, 419159, 562951, 714743, 626066, 610931, 788994, 421073, 459401, 518201, 518589, 400233, 625171, 528149, 600864, 791048, 421357, 533289, 491478, 605395, 447315, 520627, 466930, 552270, 590079, 437598, 402141, 522441, 523814, 546015, 514768, 508554, 446148, 463773, 527243, 544486, 593534, 524560, 527232, 522604, 566761, 536903, 581720, 528093, 523172, 460612, 454709, 461906, 632579, 456518, 653325, 560176, 584873, 621265, 589048);

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
  400233
  401902
  402141
  408539
  419159
  421073
  421357
  437598
  440079
  446148
  447315
  454709
  455876
  456518
  459401
  460612
  461906
  463773
  466930
  477361
  487469
  491478
  493037
  508554
  511341
  514768
  515604
  518201
  518589
  520627
  522441
  522604
  523172
  523814
  524560
  525360
  526420
  527232
  527243
  528093
  528149
  533289
  536903
  544486
  546015
  552270
  556654
  560176
  562951
  565959
  566761
  581720
  584656
  584873
  585703
  589048
  590079
  593534
  600864
  602607
  605395
  610931
  621265
  621343
  624905
  625171
  626066
  632579
  637245
  641414
  653325
  658445
  695153
  704218
  714743
  787075
  788994
  791048
  804104
  810665
]

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 (400233, 401902, 402141, 408539, 419159, 421073, 421357, 437598, 440079, 446148, 447315, 454709, 455876, 456518, 459401, 460612, 461906, 463773, 466930, 477361, 487469, 491478, 493037, 508554, 511341, 514768, 515604, 518201, 518589, 520627, 522441, 522604, 523172, 523814, 524560, 525360, 526420, 527232, 527243, 528093, 528149, 533289, 536903, 544486, 546015, 552270, 556654, 560176, 562951, 565959, 566761, 581720, 584656, 584873, 585703, 589048, 590079, 593534, 600864, 602607, 605395, 610931, 621265, 621343, 624905, 625171, 626066, 632579, 637245, 641414, 653325, 658445, 695153, 704218, 714743, 787075, 788994, 791048, 804104, 810665);

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
  400233
  401902
  402141
  408539
  419159
  421073
  421357
  437598
  440079
  446148
  447315
  454709
  455876
  456518
  459401
  460612
  461906
  463773
  466930
  477361
  487469
  491478
  493037
  508554
  511341
  514768
  515604
  518201
  518589
  520627
  522441
  522604
  523172
  523814
  524560
  525360
  526420
  527232
  527243
  528093
  528149
  533289
  536903
  544486
  546015
  552270
  556654
  560176
  562951
  565959
  566761
  581720
  584656
  584873
  585703
  589048
  590079
  593534
  600864
  602607
  605395
  610931
  621265
  621343
  624905
  625171
  626066
  632579
  637245
  641414
  653325
  658445
  695153
  704218
  714743
  787075
  788994
  791048
  804104
  810665
]

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 (400233, 401902, 402141, 408539, 419159, 421073, 421357, 437598, 440079, 446148, 447315, 454709, 455876, 456518, 459401, 460612, 461906, 463773, 466930, 477361, 487469, 491478, 493037, 508554, 511341, 514768, 515604, 518201, 518589, 520627, 522441, 522604, 523172, 523814, 524560, 525360, 526420, 527232, 527243, 528093, 528149, 533289, 536903, 544486, 546015, 552270, 556654, 560176, 562951, 565959, 566761, 581720, 584656, 584873, 585703, 589048, 590079, 593534, 600864, 602607, 605395, 610931, 621265, 621343, 624905, 625171, 626066, 632579, 637245, 641414, 653325, 658445, 695153, 704218, 714743, 787075, 788994, 791048, 804104, 810665);

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

[
  "hot horny девушк"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'hot horny девушк';

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

[
  "hot horny девушк"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'hot horny девушк';