SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496728 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496728 [ RunTime:0.001541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (136314,696895,524095,916696,359833,501743,994111,563348,56539,1009335,932448,388849,841484,919248,715538,753953,912416,492147,137952,266287,111412,78931,942879,566492,362629,654837,759527,49827,580675,505897,486489,558006,800663,786287,867844,330843,24411,428699,971674,502815,334356,591465,555537,555547,749907,259590,806228,317231,999995,47386,447062,416197,885064,802301,774690,896003,530685,546080,785511,367888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]