SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50247 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50247 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442693,993925,586008,375636,344550,814964,34666,809898,76943,66200,549756,1001307,305613,251129,795349,1027469,65648,834997,72819,261159,780159,818721,670040,789510,201992,547185,930640,507264,164415,887598,653935,147683,426075,209483,787572,851905,914875,52070,396078,749648,311620,26915,906043,502030,113150,467301,387649,119811,102134,408601,583269,282282,910694,549958,1008459,296863,68,533048,539471,546847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50247 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50247 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]