SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509780 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509780 [ RunTime:0.001838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (69621,691198,406704,72023,270634,684812,178861,301686,565304,938591,248861,16064,202431,879329,872563,525291,1018156,1027706,230000,931298,5099,744673,111242,644935,846643,248351,900777,331992,152042,572699,389711,825810,424928,273077,31856,826908,224116,262925,974009,730720,352159,155975,875785,834580,646733,836627,446941,760806,696874,601757,290870,1043112,608266,699850,229957,523718,806331,463287,873102,486886) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509780 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509780 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003392s ]