SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510573 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510573 [ RunTime:0.001503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (162758,1010695,185106,6672,639087,172176,916616,396571,815138,695046,501716,856520,352566,531341,662464,467220,164745,601135,629553,126407,325086,894075,320587,215205,42654,277911,119747,745676,242064,231760,108380,924921,297288,245346,258834,38379,364307,463053,980861,650990,944123,149853,946390,613511,250650,635359,540859,884552,295647,830296,901601,131194,323907,92074,337798,993257,519673,269929,488731,332661) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]