SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002639s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315423 LIMIT 1 [ RunTime:0.001506s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315423 [ RunTime:0.003108s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (46744,296158,402256,339019,15775,41080,574327,859882,521032,348678,476768,102642,809195,456081,60988,70047,862006,3446,469317,161692,321061,607893,775381,184534,26059,311192,781273,915727,915009,848748,180764,599898,548290,134530,699514,42936,803090,574370,834278,514671,585694,920081,316083,843905,1048222,499051,837551,323766,72532,718546,650058,784208,468261,895343,1022896,927529,915193,342204,953313,463708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004808s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000889s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000679s ]