SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401623 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401623 [ RunTime:0.004750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (865425,586174,330221,969283,324401,918632,119094,27966,177948,41759,720499,766091,217394,939951,76274,169748,771128,108787,362760,242602,568506,790200,727023,619476,412808,636662,549821,955201,891599,250499,14292,174067,258314,870880,957895,601938,910035,337999,705201,997011,305372,955526,692257,653812,425155,885924,377760,639022,157025,2329,535027,84516,547367,914155,778473,1018430,10944,904346,20909,1008523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]