SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527851 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527851 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41935,1013316,322392,393619,89430,489534,586578,702790,520397,1005644,490716,589991,212736,493780,725055,318548,904961,313696,286650,329889,780500,636805,381135,267855,513059,395116,476417,189483,300128,284315,337702,229689,256396,287429,334540,205298,453157,622177,868707,774474,606844,206587,404683,414188,803432,734564,813857,1034052,371624,874378,502971,456300,1018241,193533,238275,489185,787176,7088,416536,907153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]