SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006810 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006810 [ RunTime:0.003811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677969,652607,727373,781349,714923,269117,737093,926757,751714,614983,812006,286168,287132,247900,839413,265929,899145,932694,540049,716530,972571,741766,534455,245567,916641,999364,791678,79204,5624,443525,872831,50914,201123,1040569,230555,643617,80019,1017154,476979,984330,74188,542046,24188,448002,331282,430481,275573,217502,12721,218223,389092,282052,59755,948214,836583,144312,791247,634471,799843,370157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]