SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447429 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447429 [ RunTime:0.002373s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (228929,144744,662484,429658,250195,230481,230505,700506,804943,974047,210544,927379,801579,210446,389711,717100,391621,971117,515860,449238,672142,591613,657028,408422,783486,285711,360828,838800,136677,384969,135771,36888,540243,220767,61906,777056,721435,254425,752844,108660,72799,723373,354052,324956,957015,542144,922335,946414,168867,182210,56905,247392,938111,292646,357308,918312,19954,239638,878167,950157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001029s ]