SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291199 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291199 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18323,1030080,707855,993513,578326,267996,403831,927375,600746,614307,18891,528486,689247,567901,165897,791536,978729,558582,283078,206501,221248,903893,32609,728366,297778,523747,464764,962615,757847,656060,1018101,119720,855968,145639,131059,51535,872180,576036,266042,789052,101533,644033,369824,603681,845879,573926,784771,835765,770255,414800,835094,303557,311597,789637,1022150,831767,577500,922058,146013,30793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000736s ]