SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404912 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404912 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (889797,1008521,926355,108096,16159,366848,33005,544075,162977,497799,616264,800446,971184,908323,503607,831428,365369,139365,20375,626204,780910,4966,657325,692441,793546,518576,586947,981793,602398,1037663,536049,305615,829681,87998,570610,219432,288299,21725,943192,476058,370987,47610,95071,555231,807904,575404,703885,761670,482194,710386,429143,993829,613570,853082,293976,766376,367482,474206,597580,909765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004627s ]