SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004697 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004697 [ RunTime:0.005105s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568929,796704,702347,319856,51147,591558,327667,692581,917798,841765,289537,495772,541422,889733,421838,469297,947810,418701,254055,1029807,797475,831869,367684,113828,879971,431650,34852,257072,588675,792607,242790,475710,123628,514058,630071,897051,926954,930029,513323,479178,300085,842471,208964,137741,859353,354186,294962,41943,875738,1038214,386512,336487,963936,897491,564653,405556,137547,734529,444641,835263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004697 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004697 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]