SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437910 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437910 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642894,499364,657425,259699,954222,477051,678703,811773,318726,230719,513648,765021,179758,663930,368460,258622,425072,257788,629478,62661,81464,244491,534582,346334,1014384,194480,217981,481658,960932,942670,668041,749288,780217,552878,105905,144090,689436,54726,463934,682337,193361,973992,891609,14988,832895,351880,421338,68291,643379,807961,710482,911497,679552,357753,210011,52326,159229,798558,825489,622587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]