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

[
  "teen double penetrated"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen double penetrated' 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
  683454
  699549
  756687
  557685
  508053
  536665
  387636
  727833
  742135
  97276
  479462
  513893
  708421
  686821
  683470
  720077
  721399
  451527
  381775
  97401
  827523
  448880
  714552
  775893
  404804
  407290
  395646
  398317
  649198
  387544
  404800
  530497
  706652
  558124
  641070
  96269
  703098
  410940
  397057
  410934
  410941
  510160
  636288
  410930
  420216
  96997
  498520
  719335
  495397
  575430
  390680
  447851
  647879
  565102
  461086
  514069
  527412
  775780
  583677
  600490
  617410
  631163
  421273
  479818
  613832
  445538
  680100
  515231
  583725
  396087
  523225
]

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 (683454, 699549, 756687, 557685, 508053, 536665, 387636, 727833, 742135, 97276, 479462, 513893, 708421, 686821, 683470, 720077, 721399, 451527, 381775, 97401, 827523, 448880, 714552, 775893, 404804, 407290, 395646, 398317, 649198, 387544, 404800, 530497, 706652, 558124, 641070, 96269, 703098, 410940, 397057, 410934, 410941, 510160, 636288, 410930, 420216, 96997, 498520, 719335, 495397, 575430, 390680, 447851, 647879, 565102, 461086, 514069, 527412, 775780, 583677, 600490, 617410, 631163, 421273, 479818, 613832, 445538, 680100, 515231, 583725, 396087, 523225);

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
  96269
  96997
  97276
  97401
  381775
  387544
  387636
  390680
  395646
  396087
  397057
  398317
  404800
  404804
  407290
  410930
  410934
  410940
  410941
  420216
  421273
  445538
  447851
  448880
  451527
  461086
  479462
  479818
  495397
  498520
  508053
  510160
  513893
  514069
  515231
  523225
  527412
  530497
  536665
  557685
  558124
  565102
  575430
  583677
  583725
  600490
  613832
  617410
  631163
  636288
  641070
  647879
  649198
  680100
  683454
  683470
  686821
  699549
  703098
  706652
  708421
  714552
  719335
  720077
  721399
  727833
  742135
  756687
  775780
  775893
  827523
]

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 (96269, 96997, 97276, 97401, 381775, 387544, 387636, 390680, 395646, 396087, 397057, 398317, 404800, 404804, 407290, 410930, 410934, 410940, 410941, 420216, 421273, 445538, 447851, 448880, 451527, 461086, 479462, 479818, 495397, 498520, 508053, 510160, 513893, 514069, 515231, 523225, 527412, 530497, 536665, 557685, 558124, 565102, 575430, 583677, 583725, 600490, 613832, 617410, 631163, 636288, 641070, 647879, 649198, 680100, 683454, 683470, 686821, 699549, 703098, 706652, 708421, 714552, 719335, 720077, 721399, 727833, 742135, 756687, 775780, 775893, 827523);

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
  96269
  96997
  97276
  97401
  381775
  387544
  387636
  390680
  395646
  396087
  397057
  398317
  404800
  404804
  407290
  410930
  410934
  410940
  410941
  420216
  421273
  445538
  447851
  448880
  451527
  461086
  479462
  479818
  495397
  498520
  508053
  510160
  513893
  514069
  515231
  523225
  527412
  530497
  536665
  557685
  558124
  565102
  575430
  583677
  583725
  600490
  613832
  617410
  631163
  636288
  641070
  647879
  649198
  680100
  683454
  683470
  686821
  699549
  703098
  706652
  708421
  714552
  719335
  720077
  721399
  727833
  742135
  756687
  775780
  775893
  827523
]

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 (96269, 96997, 97276, 97401, 381775, 387544, 387636, 390680, 395646, 396087, 397057, 398317, 404800, 404804, 407290, 410930, 410934, 410940, 410941, 420216, 421273, 445538, 447851, 448880, 451527, 461086, 479462, 479818, 495397, 498520, 508053, 510160, 513893, 514069, 515231, 523225, 527412, 530497, 536665, 557685, 558124, 565102, 575430, 583677, 583725, 600490, 613832, 617410, 631163, 636288, 641070, 647879, 649198, 680100, 683454, 683470, 686821, 699549, 703098, 706652, 708421, 714552, 719335, 720077, 721399, 727833, 742135, 756687, 775780, 775893, 827523);

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

[
  "teen double penetrated"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'teen double penetrated';

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

[
  "teen double penetrated"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen double penetrated';

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 ?

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