SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433730 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433730 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629150,544213,224334,426904,275665,1012356,271223,806066,708267,408804,45934,772687,975270,238085,298128,647957,157157,1001675,800888,1006686,38823,920525,495066,468354,600019,14159,225203,254746,601318,49226,216916,515516,154028,565737,906688,149366,244454,474800,899564,722029,720309,743354,343867,688075,435133,1046023,722294,758401,664591,1001235,165866,817735,690782,144994,797228,286876,396376,800694,654451,903066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433730 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433730 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001671s ]