SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 463628 LIMIT 1 [ RunTime:0.001574s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 463628 [ RunTime:0.007050s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (962076,629325,595703,501521,505153,129807,302362,188986,181166,1045746,754506,325049,11775,500831,765593,912182,167309,195569,951672,1040003,467743,29766,306036,600759,106331,148863,917933,945221,749194,295868,33114,282729,159837,357061,453387,720764,67088,105907,432489,377569,892414,846566,429702,788507,1022991,353801,731167,329987,734083,525190,901262,1479,496678,19520,531512,29650,451470,364707,369611,509063) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 463628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 463628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]