SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017294 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017294 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644093,397700,833111,201035,962100,374399,375414,951171,183209,412290,840349,540102,13459,967686,565027,920209,78487,154411,838596,901498,501646,135294,988179,589855,559722,849967,891512,105394,721712,538986,134842,860425,707195,832266,1046570,447767,207218,616295,410110,393495,511240,207438,164596,694553,715308,968995,625696,17854,528414,103455,580430,765573,541811,451912,265171,963382,758822,307776,52964,487143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]