SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001864s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010302 LIMIT 1 [ RunTime:0.001396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010302 [ RunTime:0.002130s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123307,699974,895314,795543,105098,731435,14905,460367,52896,733261,296162,714818,487742,70747,816555,790216,88767,811244,355168,871135,492899,729686,502734,726876,92466,587190,128865,223835,355474,950015,152274,722105,91315,756968,724088,960386,849798,75510,229640,1037999,172226,369797,67353,123859,184941,309689,586756,398645,867867,343001,371224,396921,971711,182867,1034799,786993,519500,110078,801964,413506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010302 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010302 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]