SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549919 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549919 [ RunTime:0.003886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034650,504405,501140,918461,178924,274529,128832,983148,139813,807517,262880,1043824,748135,792776,959464,624742,77647,464508,85785,533237,982497,446991,646242,245797,395746,680879,945496,293902,731957,446559,565203,608008,762739,471224,361766,344630,415204,440030,758393,858890,990478,637123,435648,1621,252217,691864,844811,776215,565357,539057,133488,982966,390521,414666,109376,177699,763460,69397,618841,549863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549919 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549919 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002772s ]