SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20199 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20199 [ RunTime:0.002254s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (969934,175721,933913,190200,775308,295384,911194,791969,760837,272722,204867,266556,835316,113190,804993,78162,246471,767520,22218,61761,404841,101559,966667,88566,888143,268412,246034,972806,1043598,597934,101368,499688,121007,397140,416119,1024831,966801,397947,249521,888434,449797,869925,577111,576828,335184,909047,114758,797220,174478,345880,872152,130130,444890,782584,130398,494551,602220,674344,342656,194060) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000910s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]