SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310596 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310596 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (549999,1028490,779555,691008,498500,702486,147890,585853,215478,924361,900244,55275,873243,857423,921274,144732,794095,215040,229637,720128,166170,364577,246925,118134,343475,890647,457006,1041148,832659,632913,72574,676893,24981,832142,233681,111480,859098,99329,466400,1002796,969486,718599,99792,924906,337712,444150,439138,71180,73584,255663,509637,362536,185340,446636,951884,1042632,765169,405204,300146,727039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002776s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001871s ]