SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002034s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344064 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344064 [ RunTime:0.001909s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (297866,162889,269666,420098,612472,212836,235006,879770,154203,391164,655764,897917,852764,27098,205125,257925,154433,1021554,545468,420253,752930,467100,638666,27193,785531,1008404,13083,602570,550569,934088,274980,561195,169661,478997,619894,76922,782907,492320,437344,879813,33027,753324,746808,97530,901240,358870,867486,751306,595907,215643,862079,1003746,347882,410986,531900,944448,526935,977433,682116,714754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]