SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030148 LIMIT 1 [ RunTime:0.000690s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030148 [ RunTime:0.001493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (720323,593156,313345,610750,322859,894128,981416,138651,218901,576722,596133,440958,160736,408329,193284,974982,644810,587811,818294,728070,963816,35871,437013,483386,547283,610725,679089,64840,103882,903992,435719,318002,989323,1025734,928895,363045,439110,708151,737384,1268,684314,211936,290244,592575,552224,928741,400878,34543,776384,541202,201848,730458,538480,636702,40110,297691,518015,106639,583598,561342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004767s ]