SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001542s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567051 LIMIT 1 [ RunTime:0.001208s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567051 [ RunTime:0.002057s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264810,430809,502125,983002,572635,920617,419846,1002555,614745,889699,23159,109803,23930,835365,690040,37666,66668,661506,614502,859529,579530,302002,627306,181592,460654,807622,548661,569436,231761,876091,754748,1012851,422724,918529,169449,275041,170425,742462,536644,748293,3239,884891,41937,275456,934354,44748,561603,599037,696660,908423,186344,925247,788568,691217,1040823,79723,585785,825489,825276,986494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]