SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 231013 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 231013 [ RunTime:0.001571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (730778,364348,571470,781612,401858,717106,980143,279180,683273,741135,258419,355831,382314,813135,26839,222829,178143,935036,759538,906033,78002,105078,972125,216723,144496,660532,209454,268688,126132,612086,400389,225424,1046727,508325,303408,581621,770130,924142,1001598,477849,32818,269100,112093,807834,791265,819326,441501,70135,1034892,123253,426122,933950,185031,156494,640482,754188,892180,948556,148474,198184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 231013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 231013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001515s ]