SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 268053 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 268053 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610086,560400,948402,221234,744118,676850,728687,194479,307201,810380,468520,998395,380019,38866,219099,825872,55251,491887,28855,586754,121446,173679,497250,109233,465122,625166,756360,342856,591661,673711,65034,333529,687309,65074,56422,59942,796291,1038802,540740,606402,822182,118599,324369,802071,538596,10872,929430,520261,149525,607212,867632,102182,529928,478252,332567,620011,99241,537826,305222,225827) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 268053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 268053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]