SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 772009 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 772009 [ RunTime:0.001912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407762,823923,848306,110133,966735,110847,790572,521062,533401,14082,453749,604535,234294,257979,245841,287676,990430,598163,733764,233630,492532,109137,238698,81444,522997,845382,322371,1013375,268155,580896,547558,60882,660522,72004,384931,737210,843766,295863,996558,75219,139528,850628,692701,865889,40290,684158,85694,771066,302864,378980,504067,997413,864445,629641,178484,1016587,933579,400533,714325,1000510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 772009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 772009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000965s ]