SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001387s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52981 LIMIT 1 [ RunTime:0.000966s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52981 [ RunTime:0.002723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101753,925120,83556,227616,910810,740546,937369,557084,154895,285091,232357,46261,712800,856881,381390,227612,863293,459587,430474,150230,331619,94209,848917,523075,721459,337880,126902,927409,910735,718161,436253,507165,78189,625133,803334,543487,991067,39454,336103,708220,662259,19730,797332,259643,75123,99689,604139,670779,530238,849776,177206,60154,801595,621451,330284,332435,534474,758638,821645,44871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001237s ]