SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 96112 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 96112 [ RunTime:0.001890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840120,1044749,9676,449703,570080,137028,632839,65871,714510,36539,1047496,53860,701307,880149,313819,594478,31150,692067,553700,685106,753148,207808,869145,909189,371321,890257,791161,24201,978623,772358,1043871,27576,243641,336593,808820,905406,708584,227351,140169,716139,387848,654354,239516,15215,955784,953956,849889,389474,7361,546015,734218,584233,605504,421348,201046,858357,259277,678139,235225,383000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 96112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 96112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]