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` = 48670 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48670 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528901,318064,89101,925315,1011933,870038,106419,232404,224544,855375,505044,767761,134154,296029,439188,950141,732479,982362,282234,794808,544204,388899,290201,992507,225165,1033447,385216,631716,382397,458572,829147,168211,406717,950421,545314,795848,601988,395141,33726,479623,330169,619552,1038557,439973,489428,834339,92938,14133,116652,97665,597538,881236,423012,936321,392020,182065,394609,278722,610445,870609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]