SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002994s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 941199 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 941199 [ RunTime:0.002714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410873,113081,597090,247960,612416,1040536,857388,132625,246692,77114,1002607,11713,167857,178918,706844,891236,516501,323240,771584,815465,836367,1009559,347989,770239,89331,598717,921539,136562,450538,300785,189537,541737,1020806,47980,426738,821658,151730,836304,276103,845521,1012034,889704,783287,403386,1045766,242300,170425,57600,78858,303642,424350,796374,413630,238205,505773,1034074,266891,547528,355904,224881) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 941199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 941199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]