SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336433 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336433 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (2648,227428,350703,282805,454082,301655,998582,1036013,298347,670552,961069,205304,179206,875512,44472,503869,999459,1042401,1047751,1007459,544561,109973,189135,438420,500123,441766,109802,24092,794907,454778,666769,776708,808471,509660,960126,793550,51922,708931,259455,506318,753850,1037185,561508,322499,146284,791568,569065,893601,81884,560161,904343,84385,949814,10832,169482,502019,902687,1027542,668847,873959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]