SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340181 LIMIT 1 [ RunTime:0.000586s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340181 [ RunTime:0.001941s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294565,795687,868050,124637,99914,222751,321231,941324,413888,455194,1016663,745441,651612,453818,649916,492464,208726,744236,212942,241158,267422,871992,1014229,350057,896649,677221,558201,1046018,1021639,692443,991446,239187,733412,871019,979095,321240,845736,273593,802990,338944,702484,56953,630178,565622,670216,489660,6160,963072,63090,316,940573,977414,814714,639563,781039,678506,75354,291230,17695,901926) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001357s ]