SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001440s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016022 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016022 [ RunTime:0.002795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017357,67448,461531,467892,57663,469678,18445,167567,895181,621925,432490,439076,118560,766040,756500,163942,210534,559190,556300,271166,536094,217186,687973,636199,121657,487775,784369,303487,1027091,664339,449102,568196,242450,684130,807594,321608,393933,961562,923511,1008399,399796,259864,813386,155007,950346,172778,125496,746339,799622,813200,396104,391479,24022,354269,546248,582587,300789,381012,428407,344598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]