SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 309718 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 309718 [ RunTime:0.002237s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1228,500849,872399,976364,256142,146210,155577,268180,977562,394939,500720,28126,670934,210770,41791,438521,797762,806903,737803,489159,964095,103916,665288,628098,784678,875205,871589,795765,97278,624012,130200,463171,451158,969506,311239,219576,305038,244910,752438,304818,42116,640656,601878,87688,340901,641421,181997,147672,1020730,541382,967925,870567,1044995,438175,511402,782210,783994,406633,319888,9445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 309718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 309718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]