SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002841s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801234 LIMIT 1 [ RunTime:0.001077s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801234 [ RunTime:0.003625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367884,300782,345702,1006178,654077,279992,904683,190811,410890,1021169,59005,239005,406910,398663,999705,407511,468530,189990,271030,397348,159390,565645,80861,783654,709403,180903,765998,788049,256735,154717,875119,774778,264929,1044522,730634,418640,362819,861598,339732,692293,815142,551817,100160,467278,869833,892850,908533,386683,894188,899784,452708,158404,512814,54147,393577,260153,569900,529120,25418,290848) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801234 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801234 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002078s ]