SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 337971 LIMIT 1 [ RunTime:0.002100s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 337971 [ RunTime:0.003421s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476223,351311,402901,431812,797740,66136,357855,275160,24786,188871,896372,636589,602970,651581,326683,142506,654488,179418,281984,1033025,431395,920403,57743,513935,176039,599422,556166,703109,938955,481412,720572,985637,328827,782499,396108,241756,802597,715197,379546,566853,663189,242078,722470,667244,94471,972905,200621,59664,39488,593715,1047288,399353,539914,413083,870609,183244,369694,869124,877577,646213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 337971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 337971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]