SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 844212 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 844212 [ RunTime:0.004009s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423043,310699,89895,406566,747622,208851,739010,189188,536761,1012093,526809,1015845,452607,680881,694876,1043695,245034,382978,849198,506066,1046758,758718,868800,811383,55712,127959,570177,683673,372293,770913,65272,441918,718463,792302,786126,383615,358729,486799,571768,412714,1047491,1018933,440717,701807,932744,522638,216004,572180,878753,76758,327553,624662,169067,368143,670204,433071,422020,525517,988634,403297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 844212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 844212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]