SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516462 LIMIT 1 [ RunTime:0.000685s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516462 [ RunTime:0.002672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58814,113678,39862,305919,46376,1032050,1030454,87716,402200,429065,711383,888728,340054,984346,76130,832017,592335,19632,938923,971597,753736,839830,1020077,850846,279869,775972,22253,449570,802155,973145,597026,325723,210648,325456,511269,34997,256612,55176,316054,850883,989989,218261,97143,541642,238331,1007306,13415,5481,292355,792894,498817,245181,254060,16246,584861,576508,605948,990193,580424,332681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516462 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516462 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001392s ]