SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338393 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338393 [ RunTime:0.001500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476714,658116,107754,41118,185533,395276,721292,466790,848501,727690,865145,1046855,222848,644441,1045190,494845,612480,707732,231133,350918,5046,819394,779939,667070,616749,301286,36434,670112,394616,848135,854366,371668,403117,504773,414660,1014252,455923,736264,725504,584145,896492,327605,1006661,667790,648090,877413,656838,473507,186124,736065,135870,704241,802074,841411,955488,718704,780953,294923,473715,262946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000928s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000376s ]