SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41341 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41341 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (560369,683708,507119,564410,120359,648981,329128,1018622,214032,884410,79824,707427,583682,161178,503171,198370,829870,4890,644567,783631,790216,932635,814040,436559,771236,365493,449452,283902,271921,162996,360315,153383,293369,670273,722662,855840,111026,453657,166885,403432,18624,40586,884052,198573,422842,988072,523571,764584,360079,659141,909748,411039,629740,878666,32426,455492,561921,245295,367859,502862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]