SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 785323 LIMIT 1 [ RunTime:0.000983s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 785323 [ RunTime:0.002851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404009,433054,854815,930525,1008881,925439,603661,948247,1000140,966595,118582,327060,201704,620770,122709,742741,941123,251083,940744,196222,315178,384431,225338,425878,201151,1010556,793075,231222,615635,225204,1041018,270292,564228,328706,891805,254618,411180,869181,734792,422105,488172,369512,289681,323367,622552,83074,984446,639335,398977,573178,128519,331311,884208,181125,167031,859698,691118,160255,743843,158503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 785323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 785323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001647s ]