SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000899s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486043 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486043 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013060,81850,619294,177509,859394,169669,266479,225396,267077,737379,327411,467772,301976,865201,1150,457485,151735,591651,658643,668310,16363,834346,629329,674427,904623,303405,167523,885246,956476,228982,252927,292812,142795,526115,536675,964588,533623,884536,463589,24668,30175,226804,225317,724608,744076,1007065,318976,828861,956594,871174,144042,630318,137438,977532,101754,198011,578486,613634,235338,506341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001607s ]