SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415996 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415996 [ RunTime:0.002450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (633460,580723,501057,707776,548203,330983,526344,427709,918656,709630,770120,682789,587343,512897,189722,274088,785305,86565,945417,974135,627423,425894,844904,517460,548194,311907,134233,127147,760623,860482,1025758,31363,153107,495261,930658,330458,720588,418964,341846,657421,1015663,121581,792928,178276,870938,230408,664517,123660,695444,56013,687313,796422,819550,120817,11862,374830,171968,907876,500187,168922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415996 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415996 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]