SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343560 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343560 [ RunTime:0.001823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124602,662721,5284,869989,763157,695799,731511,590067,627870,623657,431074,1007561,716131,97665,986604,358703,828086,347295,71435,858872,503262,298108,861035,790796,512832,783777,777839,716036,344452,624038,102939,604019,148612,1025381,726198,412051,482141,624603,660705,180395,800305,921074,89298,724075,106072,325640,198824,651895,379535,170744,1008662,531189,849014,1041436,89944,836915,793420,989428,905263,624238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]