SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801049 LIMIT 1 [ RunTime:0.001428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801049 [ RunTime:0.006132s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801981,151013,490535,309966,1008243,268835,233037,187670,695422,749728,838248,483762,670322,957683,916537,1005772,913508,750317,816560,313670,1043171,702236,928921,372246,1028947,125742,772189,295786,221009,34444,922450,692202,227502,509877,6237,919217,862091,477959,174731,492307,629563,842400,841022,117039,432752,768568,877317,751304,469865,948978,319024,123370,1009514,339754,752797,673520,431154,455982,853461,415964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801049 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801049 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001097s ]