SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449000 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449000 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502251,940282,344887,28785,729741,1012802,843445,64381,118696,919474,594706,570861,458637,198412,115171,108534,11579,227757,648579,176250,1036296,534295,108381,11184,915135,1022599,45545,889423,119476,226412,324384,101591,556861,715283,514090,743997,703772,144591,164499,1047244,287485,958182,863418,900834,669447,707984,881920,753166,424554,875737,528229,647222,74612,1019019,122017,345773,335378,577041,392491,888019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449000 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449000 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]