SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194936 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194936 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (661394,1034444,740395,233595,762944,957267,3489,485021,1019232,388750,423318,89189,155804,523170,148955,835319,330485,251556,101144,906339,572630,126736,363042,768738,1005761,258976,1024722,194045,285247,633121,1005448,743215,239965,446762,750683,937147,137709,407023,70102,380001,945043,979387,140502,602296,247351,389905,518093,45945,300351,244465,1010864,352003,599498,500806,300889,41709,150188,282533,521455,176445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]