SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562796 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562796 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (645466,451762,510013,424263,446555,14786,272531,919062,540562,683239,188913,207733,74423,322589,579718,243572,283762,131172,618019,919508,667008,392887,222699,359611,88995,388375,662768,480105,320472,313910,394194,152352,696149,571007,209378,489508,1033181,917552,202917,334517,707803,294019,377136,717692,910282,943661,624217,378569,125447,158963,804276,314138,650529,1012054,1012823,402878,46967,769986,599366,914224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]