SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330522 LIMIT 1 [ RunTime:0.000557s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330522 [ RunTime:0.001932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (980929,1001605,400277,885734,972538,355853,756581,133661,378185,281190,194573,617322,481545,154948,597828,718768,425811,412940,68535,997799,164451,538914,547130,1048379,85945,546259,153966,249887,689063,935863,826180,44861,852396,736556,196115,705303,562566,584024,408579,93850,796405,256278,561718,992049,792410,725300,872051,45138,784609,182323,869791,518317,805943,482395,923665,623523,834660,800660,721898,65715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]