SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320019 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320019 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503560,840062,10460,550409,407939,468350,592493,578941,867533,836737,820957,149535,1012363,52161,758721,334046,662905,945135,479231,357283,31098,1154,68713,488877,125989,639256,465631,878591,721284,486907,766816,793767,58551,713118,31721,720482,782340,670433,71521,38282,533040,196418,969243,365405,323857,632066,245921,586930,169253,320497,585685,561893,104647,982307,651909,494080,672002,144705,718936,555849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]