SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520134 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520134 [ RunTime:0.002111s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528108,429032,826122,386627,452422,127911,605896,215628,881259,332150,558375,487696,600537,294743,784367,139732,329419,304898,501619,900464,986787,474248,769589,148842,310770,158294,894139,305067,849286,697945,75866,960342,35064,76458,436550,327862,141854,164781,954226,1010859,505395,971298,94750,509171,850235,584415,643786,689462,980270,648071,805850,914791,39210,326740,508483,406590,671078,312589,93258,584065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520134 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520134 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]