SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487846 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487846 [ RunTime:0.001890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (828903,75226,841308,746585,559369,528551,317818,6659,963847,501946,1039732,439880,849500,629117,232046,505458,55883,360258,631809,725237,145701,662451,941756,623448,194277,356334,233330,279512,432639,201127,311651,25045,201875,1044082,278053,741547,158758,1032783,351213,143230,522045,592781,527479,364532,473985,535221,1014835,1018273,757579,257051,906812,703310,693410,748270,774511,129522,155233,617653,107457,939843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]