SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002003s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529101 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529101 [ RunTime:0.002822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (851803,664101,623985,123305,729818,279403,736930,197871,615462,772893,88389,991673,717158,393236,815103,987837,477668,480264,933099,246350,717917,1011749,87102,790924,258806,261382,681407,1043255,746331,248428,53586,414537,216916,345916,224693,677219,521274,379746,197376,34768,1046304,177776,441834,684180,783448,597583,478235,853888,313738,334422,266302,703806,136721,513945,277720,471847,806856,236560,571368,47127) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]